doesn't Oracle have a to_date function or something like that? Maybe try that.
> 23-JAN-99 > > On Tue, 20 Nov 2001, Angel Stewart wrote: > > > 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/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
