How to get datetime without time with t-sql?

Question

Suppose I have variable as:

declare @dt datetime
declare @d datetime
set @dt = getdate()

then I want to get date from @dt and assign it to @d. For example, if @dt='2014-07-02 2:30:22' @t should be @d = '2014-07-02 00:00:00'

data type for @d should be same datetime, not varchar.

score 1 · Answer 1 · answered Jul 16 '14 at 18:53

1

You could cast it to DATE datatype

SELECT CAST(GETDATE() AS DATE)

answered Jul 16 '14 at 18:53

Stelian Matei

Thanks, but this return type is date, not datetime. – KentZhou Jul 16 '14 at 19:03

1 Answers1