DateTime

Sql does not just have a "Date" datatype? I see SmallDateTime and
DateTime, but what if I only want date?Not in the current version. This is planned for the next version (Yukon).
Hope this helps.
Dan Guzman
SQL Server MVP
"Jim Heavey" <JimHeavey@.nospam.com> wrote in message
news:Xns947A7A6746E9JimHeaveyhotmailcom@.
207.46.248.16...

quote:

---

> Sql does not just have a "Date" datatype? I see SmallDateTime and
> DateTime, but what if I only want date?

---

|||In addition to Dan's response, see
http://www.aspfaq.com/2206
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Jim Heavey" <JimHeavey@.nospam.com> wrote in message
news:Xns947A7A6746E9JimHeaveyhotmailcom@.
207.46.248.16...

quote:

---

> Sql does not just have a "Date" datatype? I see SmallDateTime and
> DateTime, but what if I only want date?

---

|||Key word is *planned*.
--
Mike Epprecht, Microsoft SQL Server MVP
Epprecht Consulting (PTY) LTD
Johannesburg, South Africa
Mobile: +27-82-552-0268
IM: mike@.NOSPAMepprecht.net
Specialist SQL Server Solutions and Consulting
"Dan Guzman" <danguzman@.nospam-earthlink.net> wrote in message
news:%23jHqAZq4DHA.2696@.TK2MSFTNGP09.phx.gbl...

quote:

---

> Not in the current version. This is planned for the next version (Yukon).
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Jim Heavey" <JimHeavey@.nospam.com> wrote in message
> news:Xns947A7A6746E9JimHeaveyhotmailcom@.
207.46.248.16...
>
>

---