Problems querying a date field

[SelbyGlenn]

Hi there,

I've only been writing SQL queries for about 2 days now so apologies if this is obviously wrong:


I am trying to query a field that contains dates but nothing is being returned. I was trying:

SELECT * from TABLE where AppDate = '01/09/2005'

Please help!

Thanks,



Glenn
BEng MCSE CCA

 

[PHV]

The ANSI way:
SELECT * from TABLE where AppDate = '2005-09-01'

But the syntax highly depends on which RDBMS you play with ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[SelbyGlenn]

Excellent! That worked a treat.

Thanks for the quick reply.

Glenn
BEng MCSE CCA