How to get first hour of today in SQL Server?

Question

I need to obtain today's date but instead of current time I need the first time of the date.

WRONG WAY:

'4/7/2017 4:50:13 PM'

as result of getdate() function

RIGHT WAY:

'4/7/2017 00:00:00 AM'

Thanks for your help

Select Convert(varchar(max), getdate(), 111) might work. Use varchar(whatever) you need — Yogurtu, Nov 26 '20 at 00:12

score 5 · Answer 1 · answered Apr 07 '17 at 22:32

5

How about this

        select cast(cast(getdate() as date) as datetime)

answered Apr 07 '17 at 22:32

Chuck

1 Answers1