NTOT() returns the time represented by the numeric hour, minutes and seconds specified.
Use NTOT() to construct times from numeric hour, minutes and seconds inputs.
NTOD(N1,N2,N3)
NTOT() returns the time constructed from:
| • | N1 (1 or 2 digit hour in 24-clock) |
| • | N2 (1 or 2 digit minutes) |
| • | N3 (1 or 2 digit seconds) |
If the constructed DateTime is invalid, then NTOT() returns an invalid time.
The following are examples of NTOT() using valid and invalid parameters:
NTOT(23,12,32) = ‘23:12:32‘
NTOT(23,12,70) = ‘19000101‘
NTOD(2012,08,14)+NTOT(23,12,32) = ‘20120814 23:12:32‘
The final example above illustrates combining use of the NTOD() and NTOT() functions to construct a complete DateTime field. For more information on constructing the date portion of a DateTime field see NTOD().