Archives of the TeradataForum

Message Posted: Wed, 07 Dec 2005 @ 10:01:37 GMT

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

Could any one tell me how to eliminate garbage date values and still do a successful cast operation

for example i want to cast(birth_date as date format 'DDMMYYYY') BUT this column contain some values like '00000000' that prompts me when casting column as : invalid date

Now how to resolve this issue

Brian

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