Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Comparing TimeStamp field

Re: Comparing TimeStamp field

From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Wed, 21 Dec 2005 22:16:22 -0800
Message-ID: <59adnUTiRrXU2TfeRVn-hg@comcast.com>

<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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US