Home Forums SQL Server 2008 SQL Server Newbies Convert DD-Mon-YYYY to DD/MM/YYYY RE: Convert DD-Mon-YYYY to DD/MM/YYYY

  • October 25, 2012 at 12:24 am

    #1552516

    This should get you what you are looking for. I don't know if there is a better way (I'm sure there is tho) but this seems to work OK for me.

    view sourceprint?

    1

    SELECT replace(convert(varchar(50),scheduleTime,106),' ','-') as scheduleTime