Archives of the TeradataForum

Message Posted: Fri, 30 Jun 2006 @ 08:49:32 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

The "external" form of a TIME or TIMESTAMP field is always relative to the session TIME ZONE; internal form is always GMT. In other words, when you store a value, it is converted to GMT internally based on session TIME ZONE; when you retrieve a value, it is converted to the session TIME ZONE.

The session TIME ZONE offset can be set explicitly, e.g.

     set time zone interval -'6:00' hour to minute;

or a default time zone offset can be specified for individual users and/or for the Teradata system. HELP SESSION will show the time zone offset currently in effect.

But the offset is just a time interval, not a logical / symbolic time zone name; there's no automatic handling of "daylight savings time".

	<Prev	Next>		<<First	<Prev	Next>	Last>>