Archives of the TeradataForum

Message Posted: Mon, 15 May 2006 @ 21:37:36 GMT

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

You could build a temp table with 24 rows in it to outer join to, or you could use a derived table something like this:

     (SEL TRIM(CAST((RANK(calendar_date) - 1 (FORMAT '99')) AS
     CHAR(2)))||':00'
     FROM sys_calendar.calendar
     WHERE calendar_date BETWEEN DATE AND DATE + 23) TIME_DT (RUNTIME)

JL

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