Archives of the TeradataForum

Message Posted: Thu, 15 Mar 2012 @ 20:17:05 GMT

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

James,

It is HHMISS.ss format so you can do something like

select logontime, cast(logontime as format'99:99:99.99') as for_bteq ,cast(cast(logontime as format'99:99:99.99') as char(11)) as for_sqla from dbc.logonoff

Thanks,

Robert Diehl
Travelocity Data Warehouse DBA

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