Results 1 to 3 of 3

Thread: format date

  1. #1
    Join Date
    Apr 2008

    Unanswered: format date

    How can i format date in pervasive sql?

    The day in my table is stored as "yyyymmdd"

    I want to search for records with curdate().

    select Curdate() returns 'dd/mm/yyyy'

    Any help will be appreciated.

    Thanks in advance

  2. #2
    Join Date
    Dec 2001
    Provided Answers: 6
    First, is the date stored in the table as a "Date" data type?
    If it is, you'll need to specify the date as 'yyyy-mm-dd'
    You'll need to include the single quote. For example:
    select f1 from t1 where datefield = '2008-04-10'
    Mirtheil Software
    Certified Pervasive Developer
    Certified Pervasive Technician
    Custom Btrieve/VB development
    I do not answer questions by email. Please post on the forum.

  3. #3
    Join Date
    Apr 2008
    hello Sir,

    Thanks for replying.
    My datefield in the table is not a "Date" data type.
    IT is "Decimal".I'm not allowed to change it.

    I want to run something like this:

    select * from test where datefield = curdate()-1
    datefield is of DECIMAl datatype and the format of the date is 'YYYYMMDD'.

    there are 2 option i think. One i have to convert datefield to a "date" datatype
    or convert curdate() to a decimal that displays the date as 'YYYYMMDD' instead of yyyy-mm-dd.

    Please 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