Archives of the TeradataForum

Message Posted: Wed, 12 Jun 2002 @ 18:51:26 GMT

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

HI

PLEASE HELP ME ON THIS.

I WANT TO CREATE THE MONTHS TABLE. IN THAT TABLE I NEED TWO COLUMES .ONE IS EVERY MONTHS FIRST DATE (EX 03-01-1999) AND SECOND 4TH THURSDAY (EX 03-25-1999) OF THE MONTH MARCH OF YEAR 1999.

THIS TABLE SHOULD HAVE DATES BETWEEN THESE JAN 1999 TO DEC 2099.

PLEASE TELL ME THE WAY TO DO THIS THING IN TERDATA BY USING TERADATA SQL.

Thanks

Srinivas

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