Archives of the TeradataForum

Message Posted: Tue, 08 Feb 2011 @ 12:25:38 GMT

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

Hi Experts,

I have a requirement to convert TIMESTAMP(2010-08-13 11:56:31) to DATE(20100813).

Below query I used to extract the date..

     Sel cast(Crdtd_Dt as date)..

This resulted 2010-08-13

Again I reframed it to

     sel cast(cast(Crdtd_Dt as date) AS date format 'yyyymmdd')..

Which resulted same as above 2010-08-13

Could any oney help me in fixing this..

Thanks in Advance

John

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