Hi,
I have a Date/Time column in a Table (called expiry_date), with dates in it
such as 30/09/2000
I need to run some SQL on it as shown below - but it's not returning any
results. What is the correct method of searching for dates in SQL?
SELECT body, expiry_date FROM advert_details WHERE date = '20/09/2000'
Cheers
Will
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
