Syntax
CONVERT(<number>; <string, measurement abbreviation >; <string, measurement abbreviation>)
Description
Converts a number from one measurement to another measurement.
The following measurements are available for the CONVERT function:
Measurement | Measurement abbreviation |
---|---|
Millisecond | ms |
Second | s |
Minute | m |
Hour | h |
Day | d |
Year | y |
Examples
Number | From | To | Returns |
---|---|---|---|
1000 | ms | s | 1 |
1000 | h | m | 60000 |
1000 | d | y | 2.737850787132101 |
5000 | h | d | 208.3333333333334 |