inserting only date in a column in sql server

Posted by sam on Stack Overflow See other posts from Stack Overflow or by sam
Published on 2010-05-26T06:24:08Z Indexed on 2010/05/26 6:41 UTC
Read the original article Hit count: 218

Filed under:
|

hi!

Is there a way to insert only date in a datetime column in sql server without the time? for example

date (datetime)

===============

12-01-2000

16-02-2000

or i should store this as a varchar and cast it when retriving so that i can convert to whatever form i need.

© Stack Overflow or respective owner

Related posts about sql

Related posts about sql-server