Re: SQL Problems

From: Francis <francis_at_mail.com>
Date: Tue, 06 Apr 1999 21:35:07 GMT
Message-ID: <370a7df6.11474329@bbinews.netvigator.com>

How about system time?

On Tue, 06 Apr 1999 16:15:36 GMT, "Jens Schauder" <Jens.Schauder_at_opal-edv.com> wrote:

>try something like
>
>select *
>from some_table
>where some_date = sysdate
>
>if you just want to test for the correct day
>have a look on the function trunc, round and to_char
>operating on dates
>
>cu
>Jens
>
>Francis <francis_at_mail.com> wrote in article
><370c22d8.48611579_at_bbinews.netvigator.com>...
>> How to compare the field with the system time using SQL*Plus?
>>
Received on Tue Apr 06 1999 - 16:35:07 CDT