Archives of the TeradataForum

Message Posted: Fri, 06 Apr 2007 @ 11:10:39 GMT

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

<-- Anonymously Posted: Friday, April 06, 2007 04:32 -->

Hi Guruz,

I have a string which I need to convert to date. The deal is that the string has a different format based on some conditions e.g. DDMMYYYY or YYYYMMDD. I know I can cut the string to YYYY MM DD and then concatenate to date but I am curious if there is any trick how to specify the input mask.

Thx a lot

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