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

    Unanswered: Pervasive 11/convert Julian date

    Hi,

    I have a problem with changing Julian date fromat (7 digits) to Gregorian.
    For example: 2455793 should be 2011-08-19.
    Any idea for Pervasive SQL script?

    Thanks
    badenbaden

  2. #2
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    There isn't a built-in function to convert from Julian to Gregorian dates in PSQL. You would want to use a function within your programming environment to convert the dates.
    Mirtheil Software
    Certified Pervasive Developer
    Certified Pervasive Technician
    Custom Btrieve/VB development
    http://www.mirtheil.com
    I do not answer questions by email. Please post on the forum.

Posting Permissions

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