PL/SQL time scripts

[chokri]

I'm looking for PL/SQL scripts (for Oracle)
which simulate these Sybase built-in function
DOW , HOUR , DATEADD , MINUTES , SECONDS
Thanks for your help.

[learndbms learndbms]

"chokri" <c_bendhaou@exosolve.com> wrote:
>
> I'm looking for PL/SQL scripts (for Oracle)
>which simulate these Sybase built-in function
>DOW , HOUR , DATEADD , MINUTES , SECONDS
>Thanks for your help.

Select to_char(sysdate,'hh') - HOUR
Select to_char(sysdate,'mm') - minutes
Select to_char(sysdate,'ss') - seconds
Select sysdate + 15 - gives the date after 15 days.
Is this is what you want?