Safest method i found:
UPDATE ...DateCreated=
TO_DATE('#DateFormat(form.DateCreated,"dd/mm/yyyy")#','DD/MM/YYYY')
SELECT ...WHERE trunc(DateCreated) =
TO_DATE('#DateFormat(variables.Startdate,"dd/mm/yyyy")#','DD/MM/YYYY')
Pascal
PS: US citizens can use the mask DD-MM-YYYY if they like, but with this
method it really doesn't matter
-----Original Message-----
From: Angel Stewart [mailto:[EMAIL PROTECTED]]
Sent: dinsdag 20 november 2001 16:10
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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
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
