Home » RDBMS Server » Server Administration » Saving a null to date field
Saving a null to date field [message #371201] Thu, 14 September 2000 12:03 Go to next message
Nell
Messages: 7
Registered: February 2000
Junior Member
Hi,
I am trying to save a null value to a date data type field and got this error: Value is too large for the field. Can someone tell me how I can save a null/empty string to a date field? Or is a date field sizable? I am using Oracle 7.3 Thanks.

Report message to a moderator

Re: Saving a null to date field [message #371207 is a reply to message #371201] Fri, 15 September 2000 05:26 Go to previous messageGo to next message
Mahesh Pednekar
Messages: 28
Registered: August 2000
Junior Member
Insert the record with to_date function.

to_date(null) or to_date(' ')

-)
Have a nice day.

Report message to a moderator

Re: Saving a null to date field [message #371218 is a reply to message #371201] Tue, 19 September 2000 10:33 Go to previous message
fugwai
Messages: 1
Registered: September 2000
Junior Member
thanks for the reply.
i am updating the field with a recordset in vb though. somehow without changing my code and table, i am not getting the error anymore????!!! funny.

Report message to a moderator

Previous Topic: Interesting ????
Next Topic: MEDIAN values
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 18 17:24:27 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.