Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Comparing TimeStamp field
<ashish1482_at_yahoo.com> wrote in message
news:1135230940.213993.79270_at_g14g2000cwa.googlegroups.com...
> Hi :-),
>
> I hv a TimeStamp field in a table and i want to fetch records tht fall
> in between the date range.
>
> i m using VB6 for developing front-end app.
>
> Query: SELECT * FROM TableName
> WHERE ProductionDateTime BETWEEN '01/Dec/2005' AND '21/Dec/2005'
>
> ProductionDateTime is a TimeStamp field
> this is not working. it shows no rows selected.
>
>
> thnx in advance
>
> Ashu
>
Don't use implicit conversions of strings to date. Make the explicit conversions eg to_date('21/Dec/2005','dd/mmm/yyyy') Jim Received on Thu Dec 22 2005 - 00:16:22 CST