All Forums Database
i5commuter 10 posts Joined 01/12
24 Feb 2012
Why is a missing zero in the date's month a format problem in Teradata

-- valid SELECT cast('2012/02/29' AS DATE );

-- invalid SELECT cast('2012/2/29' AS DATE );

invalid SELECT cast('2012/2/29' AS DATE FORMAT 'YYYY/MM/DD' );

What does it take to make the 2nd and 3rd commands valid?

 

Jimm 298 posts Joined 09/07
i5commuter 10 posts Joined 01/12
01 Mar 2012

Thank you.

You must sign in to leave a comment.