Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2008
    Posts
    1

    Unanswered: Error while inserting date

    I have a problem with insering a date into pervasive table.while i inserting date into my table it gives me an error calling invalid date,time or timestamp value.
    Can any one tell me what is the correct format of insering a date in to a table

    thanks




  2. #2
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    The format for a date is:
    'yyyy-mm-dd'
    You need the single quotes as well. For example:
    insert into table (dateField) values ('2008-03-25')
    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
  •