Archives of the TeradataForum

Message Posted: Mon, 11 Jul 2011 @ 09:41:40 GMT


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

Subj:		Re: Cast date to timestamp

From:		Singh, Lakhwant

Try anyone of these. All these should work:

     Insert into dt
     Select cast(cast('2011/07/11' as date ) as timestamp(6) );

     Insert into dt
     Select cast(cast('2011/07/11' as date format 'yyyy/mm/dd') as timestamp(6));

     Insert into ttmp.lakhwant values
     (cast(cast('2011/07/11' as date ) as timestamp(6) ));

     Insert into ttmp.lakhwant values
     (cast(cast('2011/07/11' as date format 'yyyy/mm/dd') as timestamp(6) ))

Thanks,

Lakhwant