formatting date output in Select query

• jollyguy4all

  SSC Veteran

  Points: 270

  More actions

  May 29, 2003 at 1:33 am

  #175739

  Hi,

  I have a table in which i store values and it also has date fields. When i type a select query the date fields are displayed as '2003-05-21 00:00:00' format.

  Is there any way that i can use some function in the select query to output the date in 'dd/mm/yyyy' format?

  Thanks in advance

  Regards

  Hitendra

• Antares686

  SSC Guru

  Points: 125444

  More actions

  May 29, 2003 at 4:41 am

  #458967

  Look at CONVERT in SQL BOL there are several format options you can use. For your needs it would be

  CONVERT(char,column,103)