Convert string field to time

[pleashelp]

Using SQL 2005. Have a char field called 'StartTime' that shows a time such as '0815' or '1430'. It seems like it should be a simple thing to convert this field to an actual time field so that it displays '8:15 am' or '2:30 pm'. Any help in doing this would be greatly appreciated. Thanks

 

[markros]

This is close - but no space

select right(convert(varchar(30),cast (stuff('0815', 3,0,':') as datetime),100),7)
select right(convert(varchar(30),cast (stuff('1430', 3,0,':') as datetime),100),7)

PluralSight Learning Library

 

[markros]

See also

http://wiki.lessthandot.com/index.php/Formatting_Dates

PluralSight Learning Library