RE: Date conversion question
- From: "Zanen van, J (Jacob)" <Jacob.van.Zanen@xxxxxxxxxxxx>
- To: <Harvinder.Singh@xxxxxxxxxxxxx>, "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>, "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 4 Oct 2007 08:12:05 +1000
What is 70111?
Could be either 1 nov 1970
Or 11 januari 1970
With no way to distinguish based on this entry alone
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
Sent: Thursday, 4 October 2007 6:47 AM
To: Bobak, Mark; oracle-l
Subject: RE: Date conversion question
Data is in format "yymmdd", for example
991123 (23 nov 1999)
421 (21 apr 1900)
60823 (23 aug 2006)
0 (1 jan 1900)
70930 (30 sep 2007)
Default Year 1900
Default Month 1
Default Day 1
-----Original Message-----
From: Bobak, Mark [mailto:Mark.Bobak@xxxxxxxxxxxxxxx]
Sent: Wednesday, October 03, 2007 4:37 PM
To: Harvinder Singh; oracle-l
Subject: RE: Date conversion question
Well, that depends on what those values actually represent...
Are they julian dates? Days/minutes/seconds since some epoch?
How would you convert 991123? What date does that represent? How about 421?
0?
Without knowing what the data means, we have no way to answer you....
-Mark
--
Mark J. Bobak
Senior Database Administrator, System & Product Technologies ProQuest
789 E. Eisenhower, Parkway, P.O. Box 1346 Ann Arbor MI 48106-1346
+1.734.997.4059 or +1.800.521.0600 x 4059
mark.bobak@xxxxxxxxxxxxxxx
www.proquest.com
www.csa.com
ProQuest...Start here.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Harvinder Singh
Sent: Wednesday, October 03, 2007 3:44 PM
To: oracle-l
Subject: Date conversion question
Hi,
We have a flat file that contains a column and the values are stored as:
991123
421
60823
0
70930
Now we are moving data from flat file to table and this column will be inserted
into Date dataype column, What is the way to insert into this table and avoid
"ORA-01821: date format not recognized" errors.
Thanks
--Harvinder
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
______________________________________________________________
This email, including any attachments, may be confidential or privileged, and
is sent for the personal attention of the intended recipient. If you have
received this email in error, please delete it immediately. The views
expressed are not necessarily those of the Rabobank Group. The Group is not
liable for the effects of any virus which may be contained in this email.
If this email contains marketing material and you do not wish to receive such
material by email in future, please reply to this email and place the words
"Remove My Details - Electronic Messages" in the Subject Header.
The Rabobank Group
Australia: 1800 025 484
New Zealand: 0800 500 933
______________________________________________________________
--
//www.freelists.org/webpage/oracle-l
Other related posts:
