2

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?

alfakini
  • 4,635
  • 2
  • 26
  • 35
Che
  • 87
  • 1
  • 1
  • 10
  • SELECT CONVERT(DATETIME,CONVERT(VARCHAR(8),GETDATE(),112)) ------------------------------------ SELECT CAST(CAST(GETDATE() AS DATE) AS DATETIME) – Spider Oct 26 '17 at 10:56

2 Answers2

2

Try below :

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

Result :

2017-10-26 00:00:00.000
Yogesh Sharma
  • 49,870
  • 5
  • 26
  • 52
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
saiibitta
  • 377
  • 2
  • 18