|
|
|
Forum Member
 
Group: Forum Members
Last Login: 9/29/2008 7:53:28 AM
Posts: 27,
Visits: 147
|
|
We have Teradata installations and the Time Zone offset by default is 0, although the Time Zone on the system is -5 GMT.
Only way we can figure out Time Zone is through ResUsage tables, where we have TheTime and GmtTime fields, taking the difference between them (and
taking TheDate into consideration) can tell us the GMT offset on the system.
We have to query Teradata with time filters from different Time Zone. By calculating the offset (as mentioned above) we can convert Time to/from our location to query according to Teradata's Time Zone.
One problem that we are facing is that when DST changes occur i.e. when DST is enabled/disabled on Teradata, we won't know about it until we check the GMT offset from ResUsage tables every time (currently we are calculating the offset once).
Is there any elegant/efficient/alternative mechanism to check for DST changes OR to do Time Zone conversions.
A man with so large a head must have something in it ((Sherlock Holmes))
|
|
|
|
|
Forum Member
Group: Forum Members
Last Login: 9/29/2008 7:53:28 AM
Posts: 27,
Visits: 147
|
|
Any Teradata gurus on this one??
A man with so large a head must have something in it ((Sherlock Holmes))
|
|
|
|
|
Forum Member
Group: Forum Members
Last Login: 9/29/2008 7:53:28 AM
Posts: 27,
Visits: 147
|
|
.
A man with so large a head must have something in it ((Sherlock Holmes))
|
|
|
|
|
Forum Member
Group: Forum Members
Last Login: 9/29/2008 7:53:28 AM
Posts: 27,
Visits: 147
|
|
Any comments, suggestions?
A man with so large a head must have something in it ((Sherlock Holmes))
|
|
|
|
|
Forum Member
Group: Forum Members
Last Login: 9/29/2008 7:53:28 AM
Posts: 27,
Visits: 147
|
|
.
A man with so large a head must have something in it ((Sherlock Holmes))
|
|
|
|