Help getting date in format YYYY-MM-DD 00:00:00.000

[bmacbmac]

Hi,

I am trying to get the current date in format YYYY-MM-DD 00:00:00.000. I have tried a bunch of options like:

select convert(char(25), convert(datetime, getdate(), 101), 121)

and

select convert(datetime, getdate(), 105)

But they all give the date/time as: 2013-09-25 16:38:42.770. I am hoping to get 2013-09-25 00:00:00.000 instead. Any idea on the way to do this?

Thanks!

 

[fredericofonseca]

select convert(datetime,convert(date, getdate(), 105),121)

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

FAQ219-2884
FAQ181-2886

 

[bborissov]

select DATEADD(dd, 0,DATEDIFF(dd, 0, GETDATE()))

Borislav Borissov
VFP9 SP2, SQL Server