Why is a missing zero in the date's month a format problem in Teradata

Database
Enthusiast

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?

2 REPLIES
Enthusiast

Re: Why is a missing zero in the date's month a format problem in Teradata

Enthusiast

Re: Why is a missing zero in the date's month a format problem in Teradata

Thank you.