Archives of the TeradataForum
Message Posted: Tue, 08 Feb 2011 @ 12:25:38 GMT
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
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|