Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2004

    Unanswered: Date Format Issue

    Hi All,

    I'm using Pervasive SQL 7 and I'm looking for a function to parse a date character string from yymmdd into mm/dd/yy. A date field from a table contains date in such format and the application that generates the data (Magic ver. 8.3) doesn't seems able to do the trick.



  2. #2
    Join Date
    Dec 2001
    Provided Answers: 4
    Is the field in a Btrieve Date format? If so, it's:
    stored as a 4 byte number with the first two bytes being the 4 digit year the third byte being the month, and the fourth byte being the day.
    How it's coming back from the database and what programming language you're using will determine the best way to manipulate it.
    Mirtheil Software
    Certified Pervasive Developer
    Certified Pervasive Technician
    Custom Btrieve/VB development
    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