TimeStamp() formats an expression as a date and time value, in the timestamp format set in the system variables in the load script, or in the operating system, unless a format string is supplied.
Syntax:
Timestamp(number[, format])
Return data type: dual
Arguments:
| Argument | Description |
|---|---|
| number | The number to be formatted. |
| format | String describing how the resulting timestamp string is to be formatted. If omitted, the short date format, time format, and decimal separator set in the operating system is used. |
Examples:
The examples below assume the following default settings:
- TimeStampFormat setting 1: YY-MM-DD hh:mm:ss
- TimeStampFormat setting 2: M/D/YY hh:mm:ss
Example 1:
Timestamp(
A )
where
A=35648.375
| Results | Setting 1 | Setting 2 |
|---|---|---|
| String: |
97-08-06 09:00:00 |
8/6/97 09:00:00 |
| Number: |
35648.375 |
35648.375 |
Example 2:
Timestamp(
A,'YYYY-MM-DD hh.mm')
where A=35648
| Results | Setting 1 | Setting 2 |
|---|---|---|
| String: |
1997-08-06 00.00 |
1997-08-06 00.00 |
| Number: |
35648 |
35648 |
