Archives of the TeradataForum

Message Posted: Tue, 15 Feb 2005 @ 14:55:19 GMT

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

In your first case, you are casting a date COLUMN to character without an explicit FORMAT, so Teradata uses the FORMAT for the column (specified or defaulted when the table was created). In the second case, you are casting a date EXPRESSION to character so the FORMAT depends on your SESSION settings instead.

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