RE: (sql) Between -- date range

2001-11-09 Thread Kevin Langevin
> 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 mailse

RE: (sql) Between -- date range

2001-11-09 Thread Owens, Howard
- > From: Bryan 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

RE: (sql) Between -- date range

2001-11-09 Thread Bryan Love
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/, so that might b