Re: Select Statement with Date

Christian Wall wrote:
>
> Hallo,
>
> I've got the following Problem:
> We have a Database, with the Fields "Personnelnumber", "EntryDate" and
> "StartTime", etc.
>
> The Type of the Fields "EntryDate" and "StartTime" is DATE
> The Primaryindex is on "Personnelnumber", "EntryDate" and "StartTime".
> Now when I try the SQL Statement
>
> SELECT * FROM ATIMES WHERE
> Personnelnumber='CW' AND
> EntryDate=To_Date('27.06.2002', 'DD.MM.YYYY') AND
> StartTime=To_DATE('15:21:00', 'hh24:mi:ss')
>
> I become no Records but when I Try
>
> SELECT * FROM ATIMES WHERE
> Personnelnumber='CW' AND
> EntryDate=To_Date('27.06.2002', 'DD.MM.YYYY')
>
> I got Records, and there is a Record with '01.01.3000 15:21:00'.
>
> What can I do if I only want to Select the Time of the Field???
>
> Thanks Chris!

Your

StartTime=To_DATE('15:21:00', 'hh24:mi:ss')

will use the current day (since you have not specified one).

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."