Lost Password?

Go Back   CodeCall Programming Forum > Web Development Forum > Database & Database Programming
Reload this Page Date in Oracle 8
Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

Vote on your favorite hash algorithm here!

Database & Database Programming MySQL, Oracle, SQL, PL/SQL, ABAP, Smart Forms, and other databases and languages. A database is an organized body of related information used in many websites (including CC).

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 10-02-2006, 07:19 PM
Ronin Ronin is offline
Programming Professional
  
Join Date: Apr 2006
Posts: 299
Credits: 3
Rep Power: 11
Ronin is on a distinguished road
Default Date in Oracle 8
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.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote

Sponsored Links
  #2 (permalink)  
Old 10-06-2006, 03:41 PM
Jordan's Avatar   
Jordan Jordan is offline
Administrator
  
Join Date: Nov 2005
Location: Hendersonville, NC
Posts: 7,397
Last Blog:
Tramp Variables
Credits: 1
Rep Power: 20
Jordan has much to be proud ofJordan has much to be proud ofJordan has much to be proud ofJordan has much to be proud ofJordan has much to be proud ofJordan has much to be proud ofJordan has much to be proud ofJordan has much to be proud ofJordan has much to be proud of
Send a message via ICQ to Jordan Send a message via AIM to Jordan Send a message via MSN to Jordan
Default
It is just SYSDATE in Oracle 8
__________________
CodeCall Blog | CodeCall Wiki | Shareware Site | Linux Forum | Write a Blog
Don't hesitate to ask any questions that you have! Check out our ASCII Calculator!
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 10-08-2006, 11:06 AM
Ronin Ronin is offline
Programming Professional
  
Join Date: Apr 2006
Posts: 299
Credits: 3
Rep Power: 11
Ronin is on a distinguished road
Default
Works perfect, thank you very much!
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old 01-07-2007, 12:29 PM
littlefranciscan
Guest
  
Posts: n/a
Credits: 0 [Check]
Default
Please ..for a newbie..what is Oracle 8? Thanks for helping me understand the terms.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #5 (permalink)  
Old 04-21-2007, 04:42 AM
rameshkumar rameshkumar is offline
Newbie
  
Join Date: Oct 2006
Posts: 20
Credits: 0
Rep Power: 8
rameshkumar is on a distinguished road
Smile
Quote:
Originally Posted by Ronin View Post
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.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote

Sponsored Links
  #6 (permalink)  
Old 04-21-2007, 04:46 AM
v0id's Avatar   
v0id v0id is offline
Super Moderator
  
Join Date: Apr 2007
Location: Denmark
Posts: 2,578
Last Blog:
CherryPy(thon)
Credits: 55
Rep Power: 28
v0id is a glorious beacon of lightv0id is a glorious beacon of lightv0id is a glorious beacon of lightv0id is a glorious beacon of lightv0id is a glorious beacon of lightv0id is a glorious beacon of light
Send a message via MSN to v0id
Default
Quote:
Originally Posted by littlefranciscan View Post
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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #7 (permalink)  
Old 08-17-2007, 12:25 AM
abi abi is offline
Newbie
  
Join Date: Aug 2007
Posts: 3
Credits: 0
Rep Power: 0
abi is on a distinguished road
Default Oracle Consulting, Oracle Development, Oracle Administration, Backup and Recovery
Quote:
Originally Posted by littlefranciscan View Post
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
Last edited by abi; 08-17-2007 at 12:26 AM. Reason: link
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

« Previous Thread | Next Thread »


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Translate date into your language Jaan PHP Tutorials 5 06-01-2007 05:23 PM
Calculate Quarterly dates from a Start date reachpradeep Database & Database Programming 0 03-05-2007 07:19 AM
Java.lang.string to mysql date reachpradeep Java Help 0 03-04-2007 08:08 AM
PHP:Tutorial The Date John PHP Tutorials 0 01-10-2007 06:10 PM
Oracle has more Flaws than MS SQL? Jordan Database & Database Programming 9 12-05-2006 09:39 AM


All times are GMT -5. The time now is 10:26 PM.

Contact Us - Programming Forum - Archive - Top

CodeCall

Contest Stats

Xav ........ 1357.94
MeTh0Dz|Reb0rn ........ 1077.71
WingedPanther ........ 919.18
marwex89 ........ 906.86
morefood2001 ........ 900.18
John ........ 890.77
Brandon W ........ 770.65
chili5 ........ 312.39
Steve.L ........ 264.99
dcs ........ 232.34

Contest Rules

CodeCall Goal

Goal: 100,000 Posts
Complete: 83%

Sponsors

Linux Forums
Electronic Music
Podnet IRC Network

Ads