Re: Extract same datetime records

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Tue, 17 May 2005 20:19:24 +0200
Message-ID: <d6dcb2$mc3$1@news2.zwoll1.ov.home.nl>

KK wrote:
> Hi,
>
>
> How to extract the records of same datetime from a table?
>
>
> I have a table 'tbl' with datatime column 'call_time'. there is no
> unique constraint or primarykey.
>
>
> How can I extract only the records of same call_time values?
>
>
> Pls assist.
>
>
> Regards.
>

They are all the same. Or similar to itself. Maybe you mean: where call_time has a certain value? try:
where call_time = to_date('20050517 20:18:30','YYYYMMDD HH24:MI:SS')

-- 
Regards,
Frank van Bortel

Received on Tue May 17 2005 - 13:19:24 CDT