Is there a direct type of hour, minute and second in sql server?

33213321 · Post time: 2020-2-18 22:00:01

michealhenry · Post time: 2020-4-23 16:00:01

only datetime or smalldatetime

fanfan1980 · Post time: 2020-4-23 18:15:01

SQL SERVER does not have a separate date type and time type

fanfan1980 · Post time: 2020-4-23 19:45:01

select convert (char (8), getdate (), 108)
--result
--------
22:46:56

(1 row (s) affected)

select convert (char (10), getdate (), 120)
--result
----------
2017-01-04

(1 row (s) affected)

33213321 · Post time: 2020-4-23 23:30:01

108
120
What do they mean?

fanfan1980 · Post time: 2020-4-24 10:45:02

108 is hh: mm: ss format
120 is yyyy-mm-dd hh: mm: ss format

		Remember me	Forgot password?
Password			Register