Archives of the TeradataForum

Message Posted: Mon, 05 Dec 2011 @ 11:24:40 GMT

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

<-- Anonymously Posted: Monday, December 05, 2011 06:20 -->

Hi,

Which version of teradata you are using.

If you are using TD 14.00.00.00 you have use td_day_of_week (current_date) instead of dayofweek and td_day_of_month(current_date) in your query and try.

Thanks

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