convert date to mm/dd/yyyy format

• JROCK

  Grasshopper

  Points: 11

  More actions

  November 13, 2014 at 9:48 am

  #298355

  I am new to SQL and trying to figure this out...Please help..

  IU need to convert the following date to mm/dd/yyyy format

  select custid, last, date

  from customer

  peridlast date

  1001test11899-12-30 00:00:00.000

  1003test21966-01-20 00:00:00.000

  1004test3 2001-01-01 00:00:00.000

  1005test4 1942-07-20 00:00:00.000

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  November 13, 2014 at 9:58 am

  #1758318

  See CAST AND CONVERT in BOL

  -- Gianluca Sartori

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738693

  More actions

  November 13, 2014 at 9:59 am

  #1758319

  Use CONVERT with the format you want. I assume you want 101.

  http://msdn.microsoft.com/en-us/library/ms187928.aspx