Archives of the TeradataForum

Message Posted: Mon, 29 Mar 2004 @ 20:27:31 GMT

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

<-- Anonymously Posted: Monday, March 29, 2004 15:19 -->

Please note: TheTime column in the ResUsageSPMA is just 'the time' with no date part. So when you use the below conversion to make it timestamp it appends currentdate to the date part. However if you had a float value with the date part preceding the time part, for example 2004/03/15 6:55:00 as 1040315065500, you will not be able to use the below cast to get it as a timestamp.

>>>> select   cast( cast( cast( cast(thetime as FORMAT '99:99:99') as
>>>> char(8)) as time(6))  as timestamp)
>>>> from DBC.ResUsageSpma

The finger-braking cast to get back the timestamp is right below. If someone can save the fingers I would certainly give him /her an award. Isn't it time that Teradata come forward to get that???? (better have a built-in for this , please )

select CAST(
             (
               CAST( (
                       ((1040315065500/1000000) (date, format 'yyyy-mm-dd')) || ' ' ||
                       ((1040315065500 mod 1000000) (format '99:99:99'))
                     )
                      AS CHAR(19)
                   )
             )
                  AS TimeStamp(0)
           ) ;

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