You can achieve it with CAST
just simple use TIME(0)
datatype in following:
SELECT CAST('2015-03-19 01:05:06.289' AS TIME(0))
OUTPUT:
01:05:06
You can achieve it with CAST
just simple use TIME(0)
datatype in following:
SELECT CAST('2015-03-19 01:05:06.289' AS TIME(0))
OUTPUT:
01:05:06