HHMMSS: Retrieving the Current Time

The HHMMSS function retrieves the current time from the operating system as an eight character string, separating the hours, minutes, and seconds with periods.

Syntax: How to Retrieve the Current Time

HHMMSS(output_format)

where:

output_format: Alphanumeric, at least A8

Note: While not actually a date-time function, HHMMSS included here for your convenience.

Top of page

Example: Retrieving the Current Time

This example,

HMMSS('A10')

creates a character string representing current time, like 12.09.47. Note that shorter output_format format will cause truncation of output.