| 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 ) |
반응형