chaleastale
asked on
How to pass in sql server's datetime default value which is 1/1/1900 from .NET code. It is possible to do System.Date.SqlTypes.SqlDateTime.DefaultValue?
How to pass in sql server's datetime default value which is 1/1/1900 from .NET code. It is possible to do System.Date.SqlTypes.SqlDa teTime.Def aultValue?
I was able to do System.Date.SqlTypes.SqlDa teTime.Min Value to get the minimum value.
Thanks in advance
Chale
I was able to do System.Date.SqlTypes.SqlDa
Thanks in advance
Chale
ASKER
Thanks for the reply. If you pass in empty string for a DateTime column, sql server will insert 1/1/1900 as a default value. I want to pass in this default value from .NET. For a certain reason, I can't passing in empty string.
I only need this default value. Not the minimum date
I only need this default value. Not the minimum date
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
you can use
DateTime.MinValue