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

[jehugaleahsa@gmail.com]

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

[jehugaleahsa@gmail.com]

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

On Feb 26, 8:38 am, "jehugalea...@g mail.com" <jehugalea...@g mail.com>
wrote:

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

Thanks.

[Cowboy \(Gregory A. Beamer\)]

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

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

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

*************** *************** *************** ****
| Think outside the box!
|
*************** *************** *************** ****
<jehugaleahsa@g mail.comwrote in message
news:812e27f9-5696-48a1-95e3-72e8beddf9ce@z1 7g2000hsg.googl egroups.com...

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

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

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

jehugaleahsa@gm ail.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]

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

"Jon Skeet [C# MVP]" <skeet@pobox.co mwrote:

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

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

Eq.

[Paul E Collins]

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

"Jon Skeet [C# MVP]" <skeet@pobox.co mwrote:

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.