Time in datatime field

Question

I have a field that stores the date and time but need to extract this so it only shows the time but shows the date as 01/01/1900.

I can extract the time using the below but need to include the data of 01/01/1900

convert(varchar(12), w.created, 114)

01/01/1900 is the epoch used by Excel. You're not, by any chance, trying to get the value so Excel can show it as a time? — Jeroen Mostert, Aug 21 '17 at 11:34

score 1 · Answer 1 · answered Aug 21 '17 at 10:53

If you are using SQL Server, then you can do:

select cast('1900-01-01' as datetime) + cast(cast(w.created as time) as datetime)

This returns the value as a datetime.

SQL Server has a time data type. It is unclear why you would want to add in a fake date, but you can.

1 Answers1