Datetime function to get specific dates 12:00AM time

Question

if any date time value provided to sql server can i get it's midnight value with some function in sql server.. for example if i provide 2013/07/03 01:34AM , i want to get it to 2013/07/03 12:00 AM.Is there a way to do it?

score 3 · Accepted Answer · edited May 23 '17 at 12:28

3

SQL Server 2008+

SELECT CAST(CAST('2013/07/03 01:34AM' AS date) AS datetime)

For older versions, see this Best approach to remove time part of datetime in SQL Server Never use anything that requires float or int or varchar conversions

edited May 23 '17 at 12:28

Community

1
1

answered Jul 03 '13 at 11:59

gbn

422,506
82
585
676

score 0 · Answer 2 · edited May 23 '17 at 12:21

0

This should give you what you need:

SELECT DATEADD(DAY, DATEDIFF(DAY, 0, InputDateField), 0)

Should be slightly quicker than cast: Most efficient way in SQL Server to get date from date+time?

edited May 23 '17 at 12:21

Community

1
1

answered Jul 03 '13 at 11:59

OCDan

1,103
1
10
19

Datetime function to get specific dates 12:00AM time

2 Answers2