Conversion
- Last UpdatedJan 19, 2015
- 1 minute read
|
Function |
Syntax |
Returns |
|---|---|---|
|
@CONVERT |
@CONVERT (value1, conversiontype) |
Conversion of value1 using conversiontype3 |
|
@DEGTORAD |
@DEGTORAD (degrees) |
Radian equivalent of provided degree measurement |
|
@RADTODEG |
@RADTODEG (radians) |
Degree equivalent of provided radian measurement |
|
@TODATE |
@TODATE (value1) |
Date format of value11 |
|
@TONUMBER |
@TONUMBER (value1) |
Numerical format of value12 |
|
@TOTEXT |
@TOTEXT (value1) |
Text format of value1 |
1Provided value1 can be in date format, where ("1" + "/" + "1" + "/" + "2005") translates to 1/1/2005 12:00AM or in numerical format (in 100-nanosecond increments from 1/1/1601) where 6.32401344E+17 also translates to 1/1/2005 12:00AM
2Converts text strings to their numerical counterparts, converts Boolean TRUE or FALSE to 1 or 0 respectively, and will convert dates, where 1/1/2005 12:00AM is converted to the number of 100-nanosecond increments from 1/1/1601 to that date, to 6.32401344E+17
3See table within Constants for a complete list of conversion types used with the @CONVERT command.