Archives of the TeradataForum

Message Posted: Fri, 29 Apr 2005 @ 12:47:46 GMT

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

The FORMAT option, when used, must be applied to data represented as character strings.

This means that if we want it to work on dates we need to carry out code such as

     select DATE (format 'YYYYbbMMMbbDD') (char(13))

Will work in SQL Assistant

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