Are these SQL Agent date and time values? I used to have my own homegrown functions but I just picked up knowledge of this lttle gem on these forums the other day:
SELECT msdb.dbo.agent_datetime(20130314, 123000);
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato