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 |