Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL Problems
Sysdate actually contains the current system date and time. Depending on
your formatting you will see different values. However it is easy to
adjust using the to_char function to convert the sysdate :
For example :
SQL> col sys_date format a24
SQL> select to_char(sysdate, 'dd-mon-yyyy hh12:mi:ss AM') sys_date from
dual;
SYS_DATE
The formatting can be changed to anything you want. Refer to any SQL*Plus book for all available options.
Hope this helps...
-Sriram
Francis wrote:
>
> 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 Wed Apr 07 1999 - 10:33:42 CDT
![]() |
![]() |