Archives of the TeradataForum

Message Posted: Tue, 31 Oct 2006 @ 13:06:25 GMT

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

prahlad.patidar wrote:

Hi Prahalad,

     SELECT (DATE '2004-03-01' - DATE '2004-01-01') MONTH;

this will give you exact months between two given dates in Teradata.

Regards,

Santosh

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