Home » RDBMS Server » Server Administration » Date Storage
Date Storage [message #54979] Sat, 21 December 2002 19:39 Go to next message
Tom Griffith
Messages: 1
Registered: December 2002
Junior Member
Can someone help settle a bet?
How does Oracle store date/time in the database?
I'm not interested in the display format but rather how is it physically stored (eg seconds since midnight from a specific date, etc.). Thanks for any info.

-tg

Report message to a moderator

Re: Date Storage [message #54982 is a reply to message #54979] Sun, 22 December 2002 18:15 Go to previous messageGo to next message
Mike
Messages: 417
Registered: September 1998
Senior Member
Copied from:
http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/server.920/a96524/c13datyp.htm#796

Oracle uses its own internal format to store dates. Date data is stored in fixed-length fields of seven bytes each, corresponding to century, year, month, day, hour, minute, and second.

Report message to a moderator

Re: Date Storage [message #54996 is a reply to message #54982] Mon, 23 December 2002 13:37 Go to previous message
sai sreenivas jeedigunta
Messages: 370
Registered: November 2001
Senior Member
One more addition to what mike said , Date occupies & bytes of space .

sai

Report message to a moderator

Previous Topic: Information About All Sessions Activity !!!
Next Topic: Personal Oracle 8.0.4 on W2K or XP?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 22:39:45 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.