GETDATE() function in SQL server

Question

When running the SQL query:

select GETDATE()

I get the below output:

2017-10-26 12:48:41.273

It displays the date and the time. But I want the output as

2017-10-26 00:00:00

How to get such a date format?

SELECT CONVERT(DATETIME,CONVERT(VARCHAR(8),GETDATE(),112)) ------------------------------------ SELECT CAST(CAST(GETDATE() AS DATE) AS DATETIME) — Spider, Oct 26 '17 at 10:56

score 2 · Accepted Answer · answered Oct 26 '17 at 10:57

2

Try below :

SELECT CONVERT(DATETIME,CONVERT(VARCHAR(12),GETDATE(),112))

Result :

2017-10-26 00:00:00.000

answered Oct 26 '17 at 10:57

Yogesh Sharma

score 0 · Answer 2 · answered Oct 26 '17 at 10:55

0

SQL Server 2012 and later versions

SELECT FORMAT(GETDATE() , 'yyyy/dd/MM HH:mm:ss')

Result

for either of the above it would return:

10/16/2013 17:00:20

answered Oct 26 '17 at 10:55

saiibitta

2 Answers2