Date in Oracle 8

[Ronin]

How do I get the current date in Oracle 8? I've read there is a commaind CURRENT_DATE and SYS_DATE in later version of Oracle but I can't figure out what the date command is for Oracle.

What format is the date in? Everytime I try to add one manually I get an incorrect format error.

[Jordan]

It is just SYSDATE in Oracle 8

[Ronin]

Works perfect, thank you very much!

[littlefranciscan]

Please ..for a newbie..what is Oracle 8? Thanks for helping me understand the terms.

[rameshkumar]

How do I get the current date in Oracle 8? I've read there is a commaind CURRENT_DATE and SYS_DATE in later version of Oracle but I can't figure out what the date command is for Oracle.

What format is the date in? Everytime I try to add one manually I get an incorrect format error.

current Date I will discuss about this matter right know current date and system date system date only execute our system and current date execute of our console because those date taking of server date from oracle and system date is simple date.

[v0id]

Please ..for a newbie..what is Oracle 8? Thanks for helping me understand the terms.

Oracle 10g, Siebel, PeopleSoft | Oracle, The World's Largest Enterprise Software Company
Oracle database - Wikipedia, the free encyclopedia

[abi]

Please ..for a newbie..what is Oracle 8? Thanks for helping me understand the terms.

hey there.....

Oracle provides a way for generating and maintaining your databases through the use of several types of querries..... if u need further help then u can visit

http://www.oracleplace.com which provides a platform for Oracle Consulting, Oracle Development, Oracle Administration, Backup and Recovery... all the tips & tricks r there...... along with the solutions to the problems

i hope it will help u & others

bubye