Hi Folks,
I’m facing a problem in displaying the date/Time data.
I uplodaed some data from DB2 server in a Lotus Notes form located in USA but the data is getting dispalyed with 1day back from the actual date.
Since the Lotus Notes Server on which i’m working and the Db2 server are both in same location this problem sholudnot arise.
Please help.
Thanks in Advance.
Sujeet.
For Example , If the data which i can see is 19/06/2008 the person in USA can see the same data with date 18/06/2008.
Subject: The time in db2 has been set to gmt of server
You will have to convert to your time zone if the data was created in daylight savings time.
From Help:
Using GMT TimeDates with Query Views based on DAVs
Query views use only the value in DB2, they do not interpret it or adjust it. You can see the query result in local time by adding the DB2 time zone into the query and using a column formula to adjust the time. For example:
“select textcol, (CURRENT_TIMEZONE/10000) as ctz, dtcol from dt.dt”
and then use a column formula to adjust the value shown to the user:
@Adjust(dt;0;0;0;CTZ;0;0)
You could get the same results by adjusting the returned timestamp using the information from @Zone:
@Adjust(dtcol;0;0;0;-@If(@Zone - @Integer( @Zone ) > 0.05;@Integer(@Zone)-1;@integer(@Zone));0;0)
Where dtcol is the selected TIMESTAMP column in DB2.
Note that a production formula may need to be a little more robust because @Zone can return an hhmm value if the server’s time zone is not a whole hour multiple away from GMT.
Although this approximates a normal Notes view, there are a few inconsistencies. For example, this shows the time correctly relative to the GMT, but it displays the date and time values relative to the DST value in the date (that is, it shows whether DST was in effect on that date or not), whereas the formula method shows the time relative to the current DST setting.