Re: Selecting records by the Time of a Date column

From: Jojo <jojo_at_nowhere.com>
Date: 1998/04/29
Message-ID: <35479AFB.89EB496F@nowhere.com>#1/1

Try

to_char(Mydate,'HH:MI') = '12:30'

joseph_sumalbag_at_bose.com
Mabuhay! (Long Live)
Commemorating the Centenial Celebration
Of Independence ( June 12 , 1898 )

Mikel Bengoa wrote:

> Hi,
>
> I have a table with a column that is a "Date" and I would like to get a set
> of records with the condition that the time part of this date is greater
> than a Value.
>
> I would like to do something like that:
>
> Select * from MyTable Where MyDate> '12:30'
>
> It does not work. How can I get it. Is there any function to get the time
> from a date?
>
> Thanks in advanced
>
> Mikel
Received on Wed Apr 29 1998 - 00:00:00 CDT