Take only Seconds from DateTime column

[jasonhuibers]

1900-01-01 13:01:45.002

In my sql select statement how can I return only the time poertion of the column? In this case: 13:01:45.002

 

[memdiscount]

Hi;

You can use convert function here.

******************************

Select Convert(varchar(20) , cast('1900-01-01 13:01:45.002' as datetime) , 114)

******************************

Thanks
Essa

 

[memdiscount]

Hi;

Just for your reference, you can play with datepart function as well to make get your required part of the datetime:

select datepart(yy, '1900-01-01 13:01:45.002')
select datepart(m, '1900-01-01 13:01:45.002')
select datepart(dd, '1900-01-01 13:01:45.002')
select datepart(hh, '1900-01-01 13:01:45.002')
select datepart(mm, '1900-01-01 13:01:45.002')
select datepart(ss, '1900-01-01 13:01:45.002')
select datepart(ms, '1900-01-01 13:01:45.002')

Thanks