The datetime stored in the DB(postgresql) is with time zone(EST), while binding the value to code it is getting converted to system local time(IST), Even while trying to fetch it as string using convertors the value get converted to local time and display at string
Please help on how to ignore the Timezone in the ModelBuilder
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
modelBuilder.Entity<TblData>(entity =>
{
var converter = new ValueConverter<DateTime, DateTime>(
v => new DateTime(),
v => DateTimeOffset.Parse(v.ToString()).DateTime);
var converter1 = new ValueConverter<string, DateTime>(
v => new DateTime(),
v => v.ToString());
entity.Property(e => e.StartTime)
.HasColumnName("start_time")
.HasColumnType("timestamp(4) with time zone");
.HasConversion(converter);
//both converters return value in localtime only
}
}
a zone specific time conversion is not possible as the API layer is dealing with multiple timezone DB's and API is deployed in both Linux and windows server.
Please help !!!
I usually set the TZ of the db user.
Will this be of any use?