Posts by Jonas Cruvinel • 11 points
1 post
-
1
votes3
answers814
viewsA: SELECT WITH STRING FORMATTING
SELECT cast(left(data,2) as nvarchar) + '-' + SUBSTRING(data,3,2) + '-' + cast(RIGHT(data,4) as nvarchar) as data FROM t_movimentacao WHERE id = 1;