store only date in sql server 2005

You could use convert if you use datetime or varchar for storing date

In Sql server 2008 you have date datatype

SELECT CONVERT(datetime, '12-1-2012', 103)
SELECT CONVERT(varchar(12), getdate(), 103)

DateTime datatype storage will have timestamp in it.

Either you convert it into desired format at the time of retrieval OR save data as a string(varchar).

Hi,
Try this:

SELECT CONVERT(VARCHAR(30), CURRENT_TIMESTAMP, 104)

Refer this[^] for different formats.

--Amit

sql server 2005 does not serve only 'Date' datatype
'Datetime' is datatype to store date & date-time values as per need,

Insert into tbl(dt) values(getdate()) 
-- result => 04/09/2012 6:20:24 PM

Insert into tbl(dt) values((CONVERT([datetime],CONVERT([varchar](10),getdate(),(102)),0))) 
-- result => 04/09/2012 12:00:00 AM
--time is 12:00:00 AM so it is negligible and in this case it will consider value as only date 

problems, while filling datetime values instead of only date values [while actually time is not require in some field],

example, voucher_date -> this field i want date only (e.g 04/09/2012 12:00:00 AM) not date-time (e.g 04/09/2012 6:20:24 PM)
if I will save datetime both
then selecting records using where condition like below will not give result

where dt='2012-09-04'
--Note: where dt>='2012-09-04' and dt<'2012-09-05' will work but direct comparison using '=' operator will not work 

Happy Coding!
:)

insert into Emp (Empid, Bdate
values (200, '2005-01-01')