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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists