Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Select Statement with Date
On 2 Jul 2002 00:22:47 -0700, Christian.Wall_at_de.tds-global.com
(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!
Hi Chris,
to_char(starttime,'hh24miss') = '152100'