[randjana]

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

[mirtheil]

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'

[randjana]

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.