 | |
How do I insert a BC date into Oracle?
comp.databases.oracle.misc comp.databases.oracle.misc
 |
| | Thread Tools | Display Modes |
#11
 
| |||
| |||
|
Re: How do I insert a BC date into Oracle? -
08-06-2008
, 10:19 AM
|
On Aug 6, 2:28*am, Geoff Muldoon <geoff.muld... (AT) trap (DOT) gmail.com> wrote: Murali says... Hi, Let's say I want to insert 104000 BC into a date field in an Oracle table? How do I do that? Is it as simple as inserting "-104000" into the date field or is it more complex than that? Any help would be appreciated. You can't. The Oracle date data type only goes back to 4712 BC And it should be inserted using a proper format mask, eg.: INSERT INTO some_table(some_date_field) VALUES(TO_DATE('-4712/01/01', 'syyyy/mm/dd')); Geoff M Does anyone know why they picked 4712 BC? That's Julian date 0000001. David Fitzjarrell- Hide quoted text - - Show quoted text - |
for THE ORACLE CALENDAR
copyright 2003 by Peter Gulutzan and Trudy Pelzer. Oracle has a year
zero error and its Julian dates do not match those produced by other
systems such as DB2.
HTH -- Mark D Powell --
#12
| |||
| |||
|
|
On Aug 6, 2:28*am, Geoff Muldoon <geoff.muld... (AT) trap (DOT) gmail.com> wrote: Murali says... Hi, Let's say I want to insert 104000 BC into a date field in an Oracle table? How do I do that? Is it as simple as inserting "-104000" into the date field or is it more complex than that? Any help would be appreciated. You can't. The Oracle date data type only goes back to 4712 BC And it should be inserted using a proper format mask, eg.: INSERT INTO some_table(some_date_field) VALUES(TO_DATE('-4712/01/01', 'syyyy/mm/dd')); Geoff M Does anyone know why they picked 4712 BC? That's Julian date 0000001. David Fitzjarrell- Hide quoted text - - Show quoted text - |
for THE ORACLE CALENDAR
copyright 2003 by Peter Gulutzan and Trudy Pelzer. Oracle has a year
zero error and its Julian dates do not match those produced by other
systems such as DB2.
HTH -- Mark D Powell --
#13
| |||
| |||
|
|
On Aug 6, 2:28*am, Geoff Muldoon <geoff.muld... (AT) trap (DOT) gmail.com> wrote: Murali says... Hi, Let's say I want to insert 104000 BC into a date field in an Oracle table? How do I do that? Is it as simple as inserting "-104000" into the date field or is it more complex than that? Any help would be appreciated. You can't. The Oracle date data type only goes back to 4712 BC And it should be inserted using a proper format mask, eg.: INSERT INTO some_table(some_date_field) VALUES(TO_DATE('-4712/01/01', 'syyyy/mm/dd')); Geoff M Does anyone know why they picked 4712 BC? That's Julian date 0000001. David Fitzjarrell- Hide quoted text - - Show quoted text - |
for THE ORACLE CALENDAR
copyright 2003 by Peter Gulutzan and Trudy Pelzer. Oracle has a year
zero error and its Julian dates do not match those produced by other
systems such as DB2.
HTH -- Mark D Powell --
#14
| |||
| |||
|
|
On Aug 6, 7:59*am, "fitzjarr... (AT) cox (DOT) net" <orat... (AT) msn (DOT) com> wrote: On Aug 6, 2:28*am, Geoff Muldoon <geoff.muld... (AT) trap (DOT) gmail.com> wrote: Murali says... Hi, Let's say I want to insert 104000 BC into a date field in an Oracle table? How do I do that? Is it as simple as inserting "-104000" into the date field or is it more complex than that? Any help would be appreciated. You can't. The Oracle date data type only goes back to 4712 BC And it should be inserted using a proper format mask, eg.: INSERT INTO some_table(some_date_field) VALUES(TO_DATE('-4712/01/01', 'syyyy/mm/dd')); Geoff M Does anyone know why they picked 4712 BC? That's Julian date 0000001. David Fitzjarrell- Hide quoted text - - Show quoted text - Geoff, if you are really interested into the Oracle date history seach for THE ORACLE CALENDAR copyright 2003 by Peter Gulutzan and Trudy Pelzer. *Oracle has a year zero error and its Julian dates do not match those produced by other systems such as DB2. HTH -- Mark D Powell --- Hide quoted text - - Show quoted text - |
range Oracle provides you have to do it yourself. First all dates are
basically estimates since the modern calendar was adopted by different
countries at different times and other calendars such as the Jewish
and Chinese calendars exist. Time values of less than a year become
fairly meaningless when you talk 2 or 3 million years BC so a number
datatype is probably your best bet.
-- Mark D Powell --
#15
| |||
| |||
|
|
On Aug 6, 7:59*am, "fitzjarr... (AT) cox (DOT) net" <orat... (AT) msn (DOT) com> wrote: On Aug 6, 2:28*am, Geoff Muldoon <geoff.muld... (AT) trap (DOT) gmail.com> wrote: Murali says... Hi, Let's say I want to insert 104000 BC into a date field in an Oracle table? How do I do that? Is it as simple as inserting "-104000" into the date field or is it more complex than that? Any help would be appreciated. You can't. The Oracle date data type only goes back to 4712 BC And it should be inserted using a proper format mask, eg.: INSERT INTO some_table(some_date_field) VALUES(TO_DATE('-4712/01/01', 'syyyy/mm/dd')); Geoff M Does anyone know why they picked 4712 BC? That's Julian date 0000001. David Fitzjarrell- Hide quoted text - - Show quoted text - Geoff, if you are really interested into the Oracle date history seach for THE ORACLE CALENDAR copyright 2003 by Peter Gulutzan and Trudy Pelzer. *Oracle has a year zero error and its Julian dates do not match those produced by other systems such as DB2. HTH -- Mark D Powell --- Hide quoted text - - Show quoted text - |
range Oracle provides you have to do it yourself. First all dates are
basically estimates since the modern calendar was adopted by different
countries at different times and other calendars such as the Jewish
and Chinese calendars exist. Time values of less than a year become
fairly meaningless when you talk 2 or 3 million years BC so a number
datatype is probably your best bet.
-- Mark D Powell --
#16
| |||
| |||
|
|
On Aug 6, 7:59*am, "fitzjarr... (AT) cox (DOT) net" <orat... (AT) msn (DOT) com> wrote: On Aug 6, 2:28*am, Geoff Muldoon <geoff.muld... (AT) trap (DOT) gmail.com> wrote: Murali says... Hi, Let's say I want to insert 104000 BC into a date field in an Oracle table? How do I do that? Is it as simple as inserting "-104000" into the date field or is it more complex than that? Any help would be appreciated. You can't. The Oracle date data type only goes back to 4712 BC And it should be inserted using a proper format mask, eg.: INSERT INTO some_table(some_date_field) VALUES(TO_DATE('-4712/01/01', 'syyyy/mm/dd')); Geoff M Does anyone know why they picked 4712 BC? That's Julian date 0000001. David Fitzjarrell- Hide quoted text - - Show quoted text - Geoff, if you are really interested into the Oracle date history seach for THE ORACLE CALENDAR copyright 2003 by Peter Gulutzan and Trudy Pelzer. *Oracle has a year zero error and its Julian dates do not match those produced by other systems such as DB2. HTH -- Mark D Powell --- Hide quoted text - - Show quoted text - |
range Oracle provides you have to do it yourself. First all dates are
basically estimates since the modern calendar was adopted by different
countries at different times and other calendars such as the Jewish
and Chinese calendars exist. Time values of less than a year become
fairly meaningless when you talk 2 or 3 million years BC so a number
datatype is probably your best bet.
-- Mark D Powell --
#17
| |||
| |||
|
|
On Aug 6, 7:59*am, "fitzjarr... (AT) cox (DOT) net" <orat... (AT) msn (DOT) com> wrote: On Aug 6, 2:28*am, Geoff Muldoon <geoff.muld... (AT) trap (DOT) gmail.com> wrote: Murali says... Hi, Let's say I want to insert 104000 BC into a date field in an Oracle table? How do I do that? Is it as simple as inserting "-104000" into the date field or is it more complex than that? Any help would be appreciated. You can't. The Oracle date data type only goes back to 4712 BC And it should be inserted using a proper format mask, eg.: INSERT INTO some_table(some_date_field) VALUES(TO_DATE('-4712/01/01', 'syyyy/mm/dd')); Geoff M Does anyone know why they picked 4712 BC? That's Julian date 0000001. David Fitzjarrell- Hide quoted text - - Show quoted text - Geoff, if you are really interested into the Oracle date history seach for THE ORACLE CALENDAR copyright 2003 by Peter Gulutzan and Trudy Pelzer. *Oracle has a year zero error and its Julian dates do not match those produced by other systems such as DB2. HTH -- Mark D Powell --- Hide quoted text - - Show quoted text - |
range Oracle provides you have to do it yourself. First all dates are
basically estimates since the modern calendar was adopted by different
countries at different times and other calendars such as the Jewish
and Chinese calendars exist. Time values of less than a year become
fairly meaningless when you talk 2 or 3 million years BC so a number
datatype is probably your best bet.
-- Mark D Powell --
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.