How to get nullable DateTime out of the database

by

A SQL null is not the same as a .NET null; you have to compare against System.DBNull.Value:

object sqlDateTime = sqldatareader[0];
DateTime? dt = (sqlDateTime == System.DBNull.Value)
    ? (DateTime?)null
    : Convert.ToDateTime(sqlDateTime);

In answer to your comment, the data type of the Item property of a DataReader is that of the underlying database type. It could be System.Data.SqlTypes.SqlDateTime for a non-null SQL Server database, or System.DBNull for a null column, or System.Data.Odbc.OdbcTypes.SmallDateTime for an ODBC database, or really just about anything. The only thing you can rely on is that it is of type object.

This is also why I suggest using Convert.ToDateTime() instead of type coercion to DateTime. There is no guarantee a ODBC or whatever date column can be coerced to a .NET DateTime. I note your comment specifies a “sqldatareader”, and a SQL Server System.Data.SqlTypes.SqlDateTime can indeed be coerced to a System.DateTime, but your original question did not tell us that.

For more information on using DataReaders, consult MSDN.

More Related Contents:

  1. Conversion of a datetime2 data type to a datetime data type results out-of-range value
  2. What does “DateTime?” mean in C#?
  3. Using DateTime in a SqlParameter for Stored Procedure, format error
  4. How can I format a nullable DateTime with ToString()?
  5. Is there any difference between DateTime in c# and DateTime in SQL server?
  6. DateTime’s representation in milliseconds?
  7. How do I use DateTime.TryParse with a Nullable?
  8. Days between two dates in asp.net
  9. How to pass an array into a SQL Server stored procedure
  10. Using StringWriter for XML Serialization
  11. format date in c#
  12. Nullable type issue with ?: Conditional Operator
  13. Invalid attempt to read when no data is present
  14. Avoiding SQL injection without parameters
  15. How do I convert an ISO8601 TimeSpan to a C# TimeSpan?
  16. How to convert Javascript datetime to C# datetime?
  17. Code to validate SQL Scripts
  18. How can I call a SQL Stored Procedure using EntityFramework 7 and Asp.Net 5
  19. Optimistic concurrency: IsConcurrencyToken and RowVersion
  20. ALTER TABLE DROP COLUMN failed because one or more objects access this column
  21. Parse a string containing date and time in a custom format
  22. Can I use ADFS 2.0 to authenticate certain users against SQL Server?
  23. How to pass a null variable to a SQL Stored Procedure from C#.net code
  24. SQL Server: Dynamic where-clause
  25. “The operation is not valid for the state of the transaction” error and transaction scope
  26. Bulk Insert Sql Server millions of record
  27. Loading PictureBox Image From Database
  28. Specify Date format in MVC5 (dd/MM/yyyy)
  29. EF Core takes a lot of time, sometimes, to perform SELECT query
  30. how are nullable types implemented under the hood in .net?

Leave a Comment