>Hi,
>
>select stuff(replace(replace(convert(varchar(30), getdate(), 126),':',''),'-',''), 9, 1, '_')
>
>
>MartinaJ
Very nice! So, no FORMAT function option, right? And how would you do the opposite conversion from character to datetime?
If it's not broken, fix it until it is.
My Blog