Querying for Dates 1

[TNGPicard]

select * from "ITMAUDIT" where customernum > 0 and dtSystemDate >= '12-1-2007'

dtSystemDate has the type datetime I believe on it (PCC errors when I try and look at the properties of the table). But this field is actually storing dates as a date.

Crystal seems to figure it out, but I sure can't, call it a this MS dba still has trouble with PSQL.

Mark

 

[mirtheil]

Dates need to be in the format:
'yyyy-mm-dd'
THe single quotes are needed.

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician

http://www.mirtheil.com