Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Location
    canada
    Posts
    230

    Unanswered: How can I convert JULIAN_DAY to regular date?

    I use db2 v8 fixpak 10 and aix 5.2

    as you know we have

    db2 "values JULIAN_DAY('2005-01-01')"
    1
    -----------
    2453372

    how can I conver 2453372 number to 2005-01-01 date , please help.

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Use the date function and subtract the offset of 1721425.
    I am not entirely sure this will work in all cases because of how the julian calendar works.

    You can try:

    values date(2453372-1721425)

  3. #3
    Join Date
    Sep 2003
    Location
    canada
    Posts
    230
    Quote Originally Posted by ARWinner
    Use the date function and subtract the offset of 1721425.
    I am not entirely sure this will work in all cases because of how the julian calendar works.

    You can try:

    values date(2453372-1721425)
    Thank you so much for your help.

Posting Permissions

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