Sybase Convert Function |
Date Format Conversion
Convert between data types or date formats.
| Style | Output (yy) |
|---|---|
| 0 | mon dd yyyy hh:miAM (or PM) |
| 1 | mm/dd/yy |
| 2 | yy.mm.dd |
| 3 | dd/mm/yy |
| 4 | yy.mm.dd |
| 5 | dd-mm-yy |
| 6 | dd mon yy |
| 7 | mon dd, yy |
| 8 | hh:mm:ss |
| 9 | mon dd yyyy hh:mi:ss:mmmAM (or PM) |
| 10 | mm-dd-yy |
| 11 | yy/mm/dd |
| 12 | yymmdd |
| Style | Output (yyyy) |
|---|---|
| 100 | mon dd yyyy hh:miAM (or PM) |
| 101 | mm/dd/yyyy |
| 102 | yyyy.mm.dd |
| 103 | dd/mm/yyyy |
| 104 | yyyy.mm.dd |
| 105 | dd-mm-yyyy |
| 106 | dd mon yyyy |
| 107 | mon dd, yyyy |
| 108 | hh:mm:ss |
| 109 | mon dd yyyy hh:mi:ss:mmmAM (or PM) |
| 110 | mm-dd-yyyy |
| 111 | yyyy/mm/dd |
| 112 | yyyymmdd |
Example: select convert( char(8), getdate(), 112 )
Last Updated: $Date: 2006/06/19 04:23:21 $ |
|