I have some questions around PXDBDate fields
I’m trying to understand when does a date field care about UTC and when does it not? Looking at SODate.OrderDate I see that it doesn’t store any time value. Jan 1st, 2023 is always that date regardless of the time when the order was placed or what my timezone setting is.
I added a date field to SO Line and when I update the value of the field there is no time component. And, yet, the column is displayed in UTC. I’m in PST (-8) so if I enter 2023-02-01 with no time component and then change my timezone, the display value changes. The database is holding no time component.
So my two questions are:
- How do I set up a Date field that does act like a UTC value? In other words, the date I’m entering is “local time” and it will adjust depending on the user’s timezone setting.
- How do I set up a Date only field that does not act like a UTC value? Like a sales order’s date field where Jan 10, 2023 on the screen matches what is stored in the database, regardless of the user’s timezone setting?
Best answer by Yuriy Zaletskyy
View original