Archives of the TeradataForum

Message Posted: Mon, 16 May 2005 @ 18:07:34 GMT

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

Hi John,

a blank is not valid within a format and MM means month not minute:

     select '12MAY05 03.04.15' (FORMAT'DDMMMYYbHH:MI:SS',TIMESTAMP(0));

     2005-05-12 03:04:15

Dieter

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