Insert only dates into a column in sql server

Question

Is there a way to insert only date in datetime column on sql server without time? eg

date (datetime)
================
12-01-2000
16-02-2000

or should I store this as varchar and cast when returning, so that I can convert whatever shape I need.

+3

sam May 26, '10 at 6:24

3 answers

SQLServer 2008, date.

SQL . , .

Select  Cast(Floor(Cast(MyDateColumn as float)) as DateTime) as MyDateColumn
From dbo.MyTable

+1

smalldatetime date. , .

sql- .

sql

!

+1

hgulyan 26 '10 7:03

Pranay rana · Accepted Answer · 2010-05-26T07:22:52+0000

My solution is to store it as varchar and convert it to datetime if necessary

SELECT CONVERT(VARCHAR(10),GETDATE(),111) -- get datepart onl y

or

also check this post about creating a date type:

create user-defined data types:

create type Date from dateTime