Many thanks for the suggestions, trunc(fieldname) seems to be the easiest
way around it
Eamonn Keating <oristech_at_tinet.ie> wrote in message
news:7os1ab$qng$1_at_scotty.tinet.ie...
> On the oracle database the following statement will not retrieve any rows
> SELECT PartCode,SPEC_REV_NO, to_char(CHANGE_DATE_TIME,'dd/Mon/yyyy
> hh24:mi:ss'), to_char(REV_DATE,'dd/Mon/yyyy'),Userid,Comments FROM
SPECAUD
> WHERE REV_DATE BETWEEN to_date( '11-Aug-1999' , 'dd-mon-yyyy') AND
> o_date( '11-Aug-1999' , 'dd-mon-yyyy')
>
> wheras the following will
>
> SELECT PartCode,SPEC_REV_NO, to_char(CHANGE_DATE_TIME,'dd/Mon/yyyy
> hh24:mi:ss'), to_char(REV_DATE,'dd/Mon/yyyy'),Userid,Comments FROM
SPECAUD
> WHERE REV_DATE BETWEEN to_date( '11-Aug-1999' , 'dd-mon-yyyy') AND
> o_date( '12-Aug-1999' , 'dd-mon-yyyy')
>
> for data on 11-Aug-1999 ?
> any help would be appreciated
>
> Regards
> Eamonn
>
>
Received on Thu Aug 12 1999 - 07:02:50 CDT
