I need how to get the last one hour in format 'hhmmss' in sql server for example if the time now is 10:48:22 i need the expected result be 9:48:22
the time now -1
Asked
Active
Viewed 146 times
-2
-
2What do you mean "last one hour", give some examples of current time vs time you expect – musefan Jul 04 '18 at 08:32
-
Maybe this https://stackoverflow.com/questions/7664608/get-time-from-getdate helps – apomene Jul 04 '18 at 08:34
-
i mean if the time now is 10:46:22 i need the result is 9:46:22 – Lamis Alaa Jul 04 '18 at 08:47
-
TRY `SELECT CONVERT(TIME(0), DATEADD(HOUR,-1,'10:46:22'))` @LamisAlaa – Killer Queen Jul 04 '18 at 09:06
-
@KillerQueen thanks alot it works – Lamis Alaa Jul 04 '18 at 09:12
-
Glad that i could help :) @LamisAlaa – Killer Queen Jul 04 '18 at 09:13
2 Answers
0
Assuming that you mean you want the time for the current hour (so for me right now, its 09:39 so you want '090000') then this would get what you're after:
SELECT REPLACE(CONVERT(varchar(8),DATEADD(HOUR, DATEDIFF(HOUR,'20000101',GETDATE()),'20000101'),14),':','');
Thom A
- 88,727
- 11
- 45
- 75
0
You appear to want:
select convert(varchar(8), cast(dateadd(hour, -1, getdate()) as time))
However, I you can probably also leave the value as a time rather than converting to a string.
Gordon Linoff
- 1,242,037
- 58
- 646
- 786