Home » SQL & PL/SQL » SQL & PL/SQL » In Date field null value gets stores like '01/01/0001'
In Date field null value gets stores like '01/01/0001' [message #344836] Mon, 01 September 2008 06:17 Go to next message
mahayog
Messages: 3
Registered: June 2005
Location: Pune
Junior Member
Hi All,

I have a support call in which data gets loaded from Lotus notes application into Oracle.

From one date field in Lotus null value is passed and in Oracle the value gets stored as '01/01/0001'.

Can anyone throw lights on it.


Thanx in advance,
Yogesh

[Updated on: Mon, 01 September 2008 06:51]

Report message to a moderator

Re: In Date field null value gets stores like '01/01/0001' [message #344847 is a reply to message #344836] Mon, 01 September 2008 07:03 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
* Is there any default value on your column?
* How do you load Oracle table?
* What is your Oracle version (4 decimals)

Regards
Michel
Re: In Date field null value gets stores like '01/01/0001' [message #344855 is a reply to message #344847] Mon, 01 September 2008 07:37 Go to previous message
mahayog
Messages: 3
Registered: June 2005
Location: Pune
Junior Member

I will ask the same to the Client and let you know.

Thanx ,
Yogesh
Previous Topic: when partitioning the table should the partitioning must also happen to indexes assiociated with tab
Next Topic: cursoe creation
Goto Forum:
  


Current Time: Thu Dec 08 00:34:43 CST 2016

Total time taken to generate the page: 0.07404 seconds