select GETDATE() as currentDate
returns
2016-01-18 10:54:31.780
How can I do that it return
2016-01-18 10:00:00
according MSDN GETDATE() has no parameterized constructor
Asked
Active
Viewed 8,425 times
0
gsiradze
- 4,583
- 15
- 64
- 111
-
1Possible duplidate of http://stackoverflow.com/questions/1114307/extracting-hours-from-a-datetime-sql-server-2005 – Andrew Jan 18 '16 at 06:59
-
select datepart(hour, getdate()) – Khazratbek Jan 18 '16 at 07:01
-
`SELECT GETDATE(), DATEADD(HOUR, DATEDIFF(HOUR, 0 , GETDATE()), 0)` – Felix Pamittan Jan 18 '16 at 07:03
-
select dateadd(hour, datediff(hour, 0, GETDATE()), 0) – Raffaello.D.Huke Jan 18 '16 at 07:03
-
@FelixPamittan that's exactly what i needed – gsiradze Jan 18 '16 at 07:03
-
If you looking for current hour i think you can use this sample SELECT CONVERT(VARCHAR(2),getdate(),108) ; – Rome Jan 18 '16 at 07:06
1 Answers
4
Try like this,
SELECT FORMAT(getdate(), 'yyyy-MM-dd:HH:00:00') as DateAndHour
StackUser
- 5,370
- 2
- 24
- 44