This discussion has been locked.

You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Date display on 6.1.2 tools

Hi,

I am hoping you can explain to me why I see the following dates displayed differently in different tools. The example below is from a single UNSAccountB record:

Database

Object Browser

Manager

My initial problem was that when using GetDate() as part of a whereclause it also returns tomorrow's date rather than today's, giving unexpected results. The database server's timezone is currently GMT+11 if that is a factor.

Parents

0 Markus Weiss-Ehlers over 7 years ago

Dates stored in the database will UTC based. The object layer converts these dates to local time based on your culture settings.

So if you are creating dates using SQL, you should use GetUTCDate instead of GetDate.
Cancel
Up 0 Down

Cancel

Reply

0 Markus Weiss-Ehlers over 7 years ago

Dates stored in the database will UTC based. The object layer converts these dates to local time based on your culture settings.

So if you are creating dates using SQL, you should use GetUTCDate instead of GetDate.
Cancel
Up 0 Down

Cancel

Children

No Data