Archives of the TeradataForum

Message Posted: Mon, 05 Dec 2011 @ 14:17:31 GMT

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

if you referring to the calendar functions in syslib than you need to use

     day_of_month(current_date),
     day_of_week(current_date)

if you have your own

     dayofmonth(current_date),
     dayofweek(current_date)

functions you might need to specify the DB where they are located.

Ulrich

www.data2knowledge.de

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