where date in select statement

#1

Hi,

I am using the pervasive control center and i keep getting an error
when I try to run this statement:

SELECT * FROM "TIMEENTRY" WHERE "TIMEENTRY"."WORKDATE" = '5-30-2005'

it has to do with the date parameter. What is the correct syntax for
this?

Thanks!

#2

Try it with 'Year-Month-Day' format

SELECT * FROM "TIMEENTRY" WHERE TIMEENTRY.WORKDATE = '2005-5-30'

HTH,
Brad Kunkel
Integrated Business, Inc.

<mptkeenan (AT) gmail (DOT) com> wrote

Quote:

Hi,

I am using the pervasive control center and i keep getting an error
when I try to run this statement:

SELECT * FROM "TIMEENTRY" WHERE "TIMEENTRY"."WORKDATE" = '5-30-2005'

it has to do with the date parameter. What is the correct syntax for
this?

Thanks!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

where date in select statement

comp.databases.btrieve comp.databases.btrieve

where date in select statement - 08-03-2005 , 03:57 PM

Re: where date in select statement - 08-04-2005 , 10:54 AM