Select Statement with Date

From: Christian Wall <Christian.Wall_at_de.tds-global.com>
Date: 2 Jul 2002 00:22:47 -0700
Message-ID: <b44bd22c.0207012322.6e0b0a94@posting.google.com>

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! Received on Tue Jul 02 2002 - 02:22:47 CDT