|
|
SRC FROM http://nstyle.egloos.com/1821836
Conversion to char functions
We outline now the conversions to strings from all the data types (we only specify the MS-SQL Server version of the interpretation of the functions):
|
Option name in the popup list |
Inserted string (where Fld is the selected field) |
|
Float [6-digit] |
CONVERT(VARCHAR, Fld, 0) |
|
Float [8-digit Scientific] |
CONVERT(VARCHAR, Fld, 1) |
|
Float [16-digit Scientific] |
CONVERT(VARCHAR, Fld, 2) |
|
Other Numeric |
CONVERT(VARCHAR, Fld) |
|
Currency [9999.99] |
CONVERT(VARCHAR, Fld, 0) |
|
Currency [9,999.99] |
CONVERT(VARCHAR, Fld, 1) |
|
Currency [9999.9999] |
CONVERT(VARCHAR, Fld, 2) |
|
Date-Time [mm/dd/yy] |
CONVERT(VARCHAR, Fld, 1) |
|
Date-Time [mm/dd/yyyy] |
CONVERT(VARCHAR, Fld, 101 ) |
|
Date-Time [yy.mm.dd] |
CONVERT(VARCHAR, Fld, 2) |
|
Date-Time [yyyy.mm.dd] |
CONVERT(VARCHAR, Fld, 102) |
|
Date-Time [dd/mm/yy] |
CONVERT(VARCHAR, Fld, 3) |
|
Date-Time [dd/mm/yyyy] |
CONVERT(VARCHAR, Fld, 103 ) |
|
Date-Time [dd.mm.yy] |
CONVERT(VARCHAR, Fld, 4) |
|
Date-Time [dd.mm.yyyy] |
CONVERT(VARCHAR, Fld, 104 ) |
|
Date-Time [dd-mm-yy] |
CONVERT(VARCHAR, Fld, 5) |
|
Date-Time [dd-mm-yyyy] |
CONVERT(VARCHAR, Fld, 105) |
|
Date-Time [dd mon yy] |
CONVERT(VARCHAR, Fld, 6) |
|
Date-Time [dd mon yyyy] |
CONVERT(VARCHAR, Fld, 106) |
|
Date-Time [Mon dd, yy] |
CONVERT(VARCHAR, Fld, 7) |
|
Date-Time [Mon dd, yyyy] |
CONVERT(VARCHAR, Fld, 107) |
|
Date-Time [mm-dd-yy] |
CONVERT(VARCHAR, Fld, 10) |
|
Date-Time [mm-dd-yyyy] |
CONVERT(VARCHAR, Fld, 110 ) |
|
Date-Time [yy/mm/dd] |
CONVERT(VARCHAR, Fld, 11) |
|
Date-Time [yyyy/mm/dd] |
CONVERT(VARCHAR, Fld, 111 ) |
|
Date-Time [yymmdd] |
CONVERT(VARCHAR, Fld, 12) |
|
Date-Time [yyyymmdd] |
CONVERT(VARCHAR, Fld, 112) |
|
Date-Time [mon dd yyyy hh:miAM] |
CONVERT(VARCHAR, Fld, 0) |
|
Date-Time [mon dd yyyy hh:mi:ss:mmmAM] |
CONVERT(VARCHAR, Fld, 9) |
|
Date-Time [dd mon yyyy hh:mm:ss:mmm] |
CONVERT(VARCHAR, Fld, 13) |
|
Date-Time [hh:mm:ss] |
CONVERT(VARCHAR, Fld, 8) |
|
Date-Time [hh:mi:ss:mmm] |
CONVERT(VARCHAR, Fld, 14) |
|
Date-Time [yyyy-mm-dd hh:mi:ss] |
CONVERT(VARCHAR, Fld, 20) |
|
Date-Time [yyyy-mm-dd hh:mi:ss.mmm] |
CONVERT(VARCHAR, Fld, 21) |
|
Date-Time [yyyy-mm-ddThh:mm:ss:mmm] |
CONVERT(VARCHAR, Fld, 126 ) |
|
|