Formatting in SQL

• Ann-176222

  SSC Enthusiast

  Points: 184

  More actions

  September 23, 2004 at 6:48 am

  #164926

  I'm new to Sql Server but used to work in Access, Sybase, Oracle.

  I'm looking for something like format(value, 'YYYYMMDD') to format a date in a custom format and format(value,'000.00') to have a custom number-format. Is this possible in sql server?

• Aaron Templeton

  SSCarpal Tunnel

  Points: 4655

  More actions

  September 23, 2004 at 6:53 am

  #524148

  Look up CONVERT in BOL ( SQL Server Books Online).

   

• vadba

  SSChampion

  Points: 11133

  More actions

  September 24, 2004 at 9:27 am

  #524360

  Many people have asked through this forum about a FORMAT() function. Unfortunately, you'll have to write your own. However, to get you started with the CONVERT() function, here are a few examples that address your specific examples.

  DECLARE @date datetime, @inum int, @fnum float

  SET @date = GetDate()

  SET @inum = 123456

  SET @fnum = 12345.6

  SELECT Convert(varchar(8), @date, 112) AS DateFormat,

         Convert(varchar(20), Convert(money, @inum), 0) AS NumFormat1,

         Convert(varchar(20), Convert(money, @fnum), 0) AS NumFormat2

• Mark-168125

  Grasshopper

  Points: 13

  More actions

  September 25, 2004 at 12:52 am

  #524413

  check out http://www.databasejournal.com/features/mssql/article.php/2197931