Archives of the TeradataForum

Message Posted: Fri, 04 Aug 2006 @ 17:02:40 GMT

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

Hi you could try:

     select
        '06/08/04 15:03:12' (timestamp(0),  format 'yy/mm/ddbhh:mi:ss')

Note, the "b" which denotes a space (blank).

Good luck

Frank

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