Home

How to get the date fields from database in the same format as front-end?

I need to extract the date columns from database in the same format as shown on the front-end. Currently I am able to get the correct date and time formats, but am unable to extract the corresponding time zone abbreviation. For example, a change has the current fields:

Rev Release Date: 31-Oct-2019 08:47:08 AM CDT

Effectivity Date: 28-Nov-2019 06:00:00 PM CST

However, I am unable to determine via the database as to which field I have to display in CST and which in CDT.

Any help in this matter would be appreciated.

Agile User Asked on July 2, 2020 in Agile PLM (v9).
Add Comment
Cancel
1 Answer(s)

Each user profile converts the date stamp to local time hence why the report does not match.

Cancel
Agile Angel Answered on November 9, 2020.
Add Comment
Cancel

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.