Simple Question - Does SQL Server 2005 Allows NULL for DateTime?

[jehugaleahsa]

Does SQL Server 2005 Allows NULL for DateTime? Just checking.

[jehugaleahsa]

On Feb 26, 8:38*am, "[e-mail]" <[e-mail]>
wrote:

Does SQL Server 2005 Allows NULL for DateTime? Just checking.

Thanks.

[Cowboy \(Gregory A. Beamer\)]

If the database table is set up that way? Yes.

--
Gregory A. Beamer
MVP, MCP: +I, SE, SD, DBA

*************************************************
| Think outside the box!
|
*************************************************
<je**********@gmail.comwrote in message
news:81**********************************@z17g2000 hsg.googlegroups.com...

Does SQL Server 2005 Allows NULL for DateTime? Just checking.

[=?ISO-8859-1?Q?Arne_Vajh=F8j?=]

je**********@gmail.com wrote:

Does SQL Server 2005 Allows NULL for DateTime? Just checking.

I am pretty sure that all relational databases by definition has to
support NULL for all data types.

Arne

[Paul E Collins]

"Jon Skeet [C# MVP]" <sk***@pobox.comwrote:

Well, so long as you're not using .NET 1.1 there's the fairly obvious
choice of Nullable<DateTime(aka "DateTime?").

SqlDateTime is a bit safer because its MinValue and MaxValue match those
of SQL Server.

Eq.

[Paul E Collins]

"Jon Skeet [C# MVP]" <sk***@pobox.comwrote:

I also tend to avoid using MinValue and MaxValue in the first place,
as they're rarely useful values.

Yes, I suppose I only ever used MinValue as a "no date" flag before C#
had nullable structs.

Eq.