Archives of the TeradataForum

Message Posted: Thu, 23 Sep 2004 @ 10:29:50 GMT

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

Azhar S Mohammad wrote:

There's no build-in function, but the following calculation works even for a date before >1900-01-01'

     (EXTRACT(YEAR FROM col) * 10000 + 0101) - 19000000 (DATE)

Dieter

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