var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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
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'
Certified Pervasive Developer
Certified Pervasive Technician
Custom Btrieve/VB development
I do not answer questions by email. Please post on the forum.
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.