Convert date to a format of dd/mm/yyyy HH:mm:ss

• SQL_Kills

  Hall of Fame

  Points: 3154

  More actions

  September 18, 2013 at 8:56 am

  #278027

  Hi,

  I have the following sql

  Select '2013-09-17 21:01:00.000'

  I want this the date to show as:

  17/09/2013 21:01:00

  I have tried the following sql but does not change to do the format I require

  Select CONVERT(varchar,'2013-09-17 21:01:00.000',103)

  Thanks

• SQL_Kills

  Hall of Fame

  Points: 3154

  More actions

  September 18, 2013 at 9:06 am

  #1651155

  I'm being thick, sorted it now:

  Select

  convert(varchar,convert(datetime,'2013-09-17 21:01:00.000'),103)+' '+convert(varchar,convert(datetime,'2013-09-17 21:01:00.000'),108)