Removing Date From Date/Time Column

Question

I have a column, [RESULT_DT_TM] which contains both date and time values. It looks like like this:

     RESULT_DT_TM
 2015-04-27  12:54:02
 2015-04-27  13:34:07

I would like the column to look like this:

     RESULT_DT_TM
       12:54:02
       13:34:07

Do you want change the result in the select or the type on the table? — Juan Carlos Oropeza, Dec 10 '18 at 20:27
Thanks all, the CAST( RESULT_DT_TM AS time(0)) code provided by @Dan Guzman works the best! — Raven, Dec 10 '18 at 20:36

Ilyes · Accepted Answer · 2018-12-10T20:43:39.793

0

Simply

SELECT CAST(RESULT_DT_TM AS TIME) RESULT_DT_TM 
FROM YourTable

Returns:

+--------------+
| RESULT_DT_TM |
+--------------+
| 12:54:02     |
| 13:34:07     |
+--------------+

edited Dec 10 '18 at 20:43

answered Dec 10 '18 at 20:31

Ilyes

1 Answers1