RE: (sql) Between -- date range

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/, so that might be your issue. -Deanna So: to_date

RE: (sql) Between -- date range

Love [SMTP:[EMAIL PROTECTED]] Sent: Friday, November 09, 2001 1:06 PM To: CF-Talk Subject: RE: (sql) Between -- date range 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

RE: (sql) Between -- date range

For some reason, the next day (after I sent this), the query started working properly. I didn't change a thing. It just started working. Gremlins. Definitely Gremlins. Kevin Langevin Web Guy In Charge UsWebGuys 954-327-5780 ~~ Get the