Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2011
    Posts
    1

    Unanswered: SQL to convert yyyy/mm/dd to julian date in as400 db2

    Hi,

    Can anyone pls post sql to convert yyyy/mm/dd to julian date in AS400400 db2.


    Thanks

  2. #2
    Join Date
    Feb 2008
    Location
    Japan
    Posts
    3,483
    DB2 for iSeries supports JULIAN_DAY built-in function(at least, since DB2 v5r2).

Posting Permissions

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