Archives of the TeradataForum

Message Posted: Fri, 26 Mar 2004 @ 15:12:54 GMT

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

   select current_timestamp (date);

as this works well, we get excepted results.

   select *
   from sys_calendar.calendar
   where calendar_date = current_timestamp(date) ;

This on the other hand does not.

   select *
   from sys_calendar.calendar
   where calendar_date = current_timestamp ;

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