Farrell... there is a 2 steps solution... i think this will work fine... at least it worked with my configuration...
But I suggest that you take a look at BOL, under topic CAST & CONVERT... there is a table comparing the diferent kinds of convertions that you can perform using cast and covert functions.
declare @date datetime
@Date = convert(datetime, (year+'-'+month+'-'+day+' '+time+':00'), 102)
SELECT convert(varchar(20),@date,110)+' '+convert(varchar(20),@date,108)
Sr. Software Developer