How to: |
The HHMS function converts a date-time value to a time value.
HHMS(datetime, length, output)
where:
Date-time
Is the date-time value to be converted.
Numeric
Is the length of the returned time value. Valid values are:
Time
HHMS converts the date-time field TRANSDATE to a time value with format HHIS:
HHMS(TRANSDATE, 8, 'HHIS')
For 2000/06/26 05:45, the output is 05:45:00
iWay Software |