You need to use the to_date function...
For Inserting, use to_date on your variable to_date('#mydate#',
'DD-MON-YYYY HH:MI:SS AM')
And for selecting, you need to use a to_char on your field name...
Try this..
SELECT * FROM tblMainEntry,TblDetailEntry
WHERE tblMainEntry.EmpID = 60597
AND to_char(tblDetailEntry.REcordDate, 'MM-DD-YYYY') = '11-30-2001';
Brian Yager
President - North AL Cold Fusion Users Group
Sr. Systems Analyst
NCCIM/CIC
[EMAIL PROTECTED]
(256) 842-8342
-----Original Message-----
From: Angel Stewart [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 20, 2001 9:10 AM
To: CF-Talk
Subject: Testing SQL statements
How in the HECK do you enter dates into Oracle?
I have tried several variations of a simple date in SQL Plus, and
nothing seems to work. I keep getting an error saying Not a valid month.
This is with raw SQL, not going through CF.
SELECT * FROM tblMainEntry,TblDetailEntry
WHERE tblMainEntry.EmpID = 60597
AND tblDetailEntry.REcordDate = '11-30-2001';
DAMMIT to HELLS!
-Gel
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
