Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2009
    Posts
    4

    Unanswered: Does any have a DB2 Fiscal Calendar create script down to the hour?

    Does any have a DB2 Fiscal Calendar create script down to the hour?

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    This one ????

    Code:
    with temp(st_dt) as 
    (
    values(date('2009-04-06') )
    )
    ,
    dt_tm_rec(dt,tm) as 
    (
    select st_dt,time('00.00') from temp
    union all 
    select date(timestamp(dt,tm)+1 hour),time(timestamp(dt,tm)+1 hour) from dt_tm_rec, temp where dt<(st_dt+1 year-1 day)
    )
    select  dt,tm from dt_tm_rec
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •