to_date() converts a string to a date type in Oracle. The mask specifies
the how Oracle should pick apart the string. If you use to_date() on a date
field it will err.
Bryan Love Macromedia Certified Professional
Internet Application Developer / Database Analyst
Telecommunication Systems Inc.
[EMAIL PROTECTED]
"What father would hesitate to say 'if there must be trouble let it be in my
day, that my child may have peace'?"
- Thomas Paine, An American Crisis
-----Original Message-----
From: Deanna Schneider [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 08, 2001 11:48 AM
To: CF-Talk
Subject: Re: (sql) Between -- date range
Howard,
I'd suggest throwing the same to_date format around the column name, so that
you're sure that you're comparing apples to apples. The default oracle date
format is dd/mmm/yyyy, so that might be your issue.
-Deanna
So:
to_date(SellDate, 'mm/dd/yyyy') BETWEEN TO_DATE('#form.StartDate#',
'MM/DD/YYYY') AND
TO_DATE('#form.EndDate#', 'MM/DD/YYYY')
Deanna Schneider
Interactive Media Developer
[EMAIL PROTECTED]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
