SQLServer remove Date part of datetime

Asked Jul 15 '14 at 14:37

Active Jul 15 '14 at 14:53

Viewed 57 times

I'm looking for a way to remove the date part of a datetime in SqlServer

So if I have something like

2012-09-29 12:45:00.0000000

I want to get

12:45:00.0000000

Any clue?

I did found a lot of examples to remove the time part of a date but not the other way around...

EDIT: As I said, this is different from other solutions found because the other ones only get the Date part and not the time part. Also, might make a difference, it has to by typed (time) as I also found solutions that convert to text based result

edited Jul 15 '14 at 14:53

asked Jul 15 '14 at 14:37

Georges Legros

2,364
2
22
41

I think [this](http://stackoverflow.com/a/3656549/369450) answers your question: `SELECT CONVERT(TIME, your_datetime_column)`. – Uyghur Lives Matter Jul 15 '14 at 15:22
Indeed, thanks a lot! – Georges Legros Jul 17 '14 at 07:56

SQLServer remove Date part of datetime

0 Answers0