Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Field Datatype

Author  Topic 

dr223
Constraint Violating Yak Guru

444 Posts

Posted - 2010-06-04 : 09:12:50

Hi,

I have a field called changedate in my tbltest. The field's data type is set as datetime.

The table is populated when the data for changedate is empty it is set to 01/01/00. I want it to say NULL. Can I update this on the table level?

Thanks

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2010-06-04 : 09:22:18
Dont send empty value. Send NULL
Refer
http://beyondrelational.com/blogs/madhivanan/archive/2008/09/02/empty-string-and-default-values.aspx

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

dr223
Constraint Violating Yak Guru

444 Posts

Posted - 2010-06-04 : 09:45:54
Thanks but am using python is there a way I can change DBNULL.Value in python.

DBNULL.Value will work fine with VB.Net

Thanks
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2010-06-04 : 09:55:57
quote:
Originally posted by dr223

Thanks but am using python is there a way I can change DBNULL.Value in python.

DBNULL.Value will work fine with VB.Net

Thanks


You need to post it in Python forum

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -