Archives of the TeradataForum

Message Posted: Thu, 14 Apr 2011 @ 15:54:36 GMT

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

JAMES PARK wrote:

The "Time" columns in some old dbc tables are actually FLOATs with a FORMAT to make them look like a TIME (neither TIME nor TIMESTAMP existed in early TD releases).

     DATE + FLOAT -> TIMESTAMP:
     cast(LogDate as timestamp(2))
     + cast(trim(LogTime) as interval hour to second)

Dieter

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