Hi,
I'm using mvc version 13.0.
datetime fields are not being converted to the time zone defined in host settings.
added in PreInitialize for CoreModule: Clock.Provider = ClockProviders.Utc;
the values are correctly saved in UTC in the database, but when retrieved in a query and displayed in HTML they continue to show in UTC
the converted value should be 12/01/2024 09:02:24
5 Answer(s)
-
0
Hi @ricardo
Do you use MVC UI or Angular UI ?
-
0
I'm using mvc (Asp.Net Zero version 13.0)
-
0
Hi @ricardo
For MVC side, only tables are automatically handled. If you are showing this date in a cshtml file, you will get the UTC value and you need to convert it to user's timezone using
ITimeZoneConverterand then display it. -
0
Hi @ismcagdas,
Thanks for the feedback.
And in the service layer, the date will always be returned in UTC when received from the database? Or should it be converted to the logged in user's time zone?
I'm using a DevExpress grid, how could I do this date conversion?
-
0
Hi,
- Yes, it will be retrieved as UTC from database.
- In that case, you can use a custom render funciton (I guess DevExpress grid supports it) and then use https://github.com/aspnetboilerplate/aspnetboilerplate/blob/dev/src/Abp.Web.Resources/Abp/Framework/scripts/abp.js#L905 to convert date to current user's timezone.
