How to: |
The HTMTOTS function returns a timestamp using the current date to supply the date components of its value, and copies the time components from its input date-time value.
HTMTOTS(time, length, output)
where:
Date-Time
Is the date-time value whose time will be used. The date portion will be ignored.
Integer
Is the length of the result. This can be one of the following:
12 for input time values including nanoseconds.
Date-Time
Is the timestamp whose date is set to current date, and whose time is copied from time.
This example produces a timestamp, whose date and time are current, and stores the result in a column with the format in the field HMDYYS:
HMDYYS = HTMTOTS(DT(&MYTOD), 8, 'HMDYYS');
The result is 03/26/2004 13:48:14.
iWay Software |