InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comWed, 03 Dec 2008 16:45:55 GMT20http://www.teradata.com/teradataforum/Topic12194-9-1.aspx.Thu, 21 Aug 2008 14:30:28 GMTmonisiqbalhttp://www.teradata.com/teradataforum/Topic12194-9-1.aspxAny comments, suggestions?Mon, 11 Aug 2008 01:13:49 GMTmonisiqbalhttp://www.teradata.com/teradataforum/Topic12194-9-1.aspx.Fri, 01 Aug 2008 03:11:45 GMTmonisiqbalhttp://www.teradata.com/teradataforum/Topic12194-9-1.aspxAny Teradata gurus on this one??Mon, 28 Jul 2008 10:53:13 GMTmonisiqbalhttp://www.teradata.com/teradataforum/Topic12194-9-1.aspxWe 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.Wed, 23 Jul 2008 00:59:42 GMTmonisiqbal