Archives of the TeradataForum

Message Posted: Thu, 01 Mar 2012 @ 23:33:22 GMT

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

     select cast (0228 as DATE) (format 'yyyy/mm/dd');

      *** Query completed. One row found. One column returned.
      *** Total elapsed time was 1 second.

            228
     ----------
     1900/02/28    <- 1900 is not a leap year

-dave.clark

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