Archives of the TeradataForum

Message Posted: Wed, 07 Dec 2005 @ 13:28:54 GMT

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

Can you do something like:

     CAST((
     CASE Birth_Dt
     WHEN '00000000' then 00010101
     ELSE BIRTH_DT
     END) AS DATE FORMAT 'DDMMYYYY')

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