I am needing some help with date field issues. I have a date field that I

marieh over 8 years ago

I am needing some help with date field issues.
I have a date field that I am saving to the db as local(now()). Then when it gets pulled from the db it is one day in the past. Then when I display it with local or with out local it is two days in the past. I have even got rid of the local when saving to db and it still does the same thing. Does any one have any suggestions?

Discussion posts and replies are publicly visible

Parents

0 peterf over 8 years ago

Local applies a fixed time zone offset relative to GMT - not relative to your process model time, so if your process model is set to use your local timezone I would expect this to give an invalid result. Even though your database may store date/time values as GMT (that is normal practice) it is rendered in the user or process model time zone after it is read back from the DB
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 peterf over 8 years ago

Local applies a fixed time zone offset relative to GMT - not relative to your process model time, so if your process model is set to use your local timezone I would expect this to give an invalid result. Even though your database may store date/time values as GMT (that is normal practice) it is rendered in the user or process model time zone after it is read back from the DB
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data