Time#() evaluates an expression as a time value, in the time format set in the data load script or the operating system, unless a format string is supplied..
Syntax:
time#(text[, format])
Return data type: dual
Arguments:
| Argument | Description |
|---|---|
| text |
The text string to be evaluated. |
| format |
String describing the format of the text string to be evaluated. If omitted, the short date format, time format, and decimal separator set in the operating system is used. |
Example:
- Time format default setting 1: hh:mm:ss
- Time format default setting 2: hh.mm.ss
time#( A )
where
A=09:00:00
| Results | Setting 1 | Setting 2 |
|---|---|---|
| String: |
09:00:00 |
09:00:00 |
| Number: |
0.375 |
- |
Example:
- Time format default setting 1: hh:mm:ss
- Time format default setting 2: hh.mm.ss
time#(
A, 'hh.mm' )
where
A=09.00
| Results | Setting 1 | Setting 2 |
|---|---|---|
| String: |
09.00 |
09.00 |
| Number: |
0.375 |
0.375 |