Home Forums SQL Server 2014 Development - SQL Server 2014 SQL Function to convert date time to string RE: SQL Function to convert date time to string
nelia.dragoo
SSC Rookie
Points: 31
More actions
January 28, 2014 at 3:55 pm
#1684093
Greetings!
Would using date type 112 not remove the need to replace the "/" characters in the date string?
This would reduce the date string portion from
REPLACE(CONVERT(VARCHAR(10),@dt,111),'/','')
to
CONVERT(VARCHAR(8),@dt,112)