Skip to main content


Returns the current local date and time.




None. The parentheses are mandatory.


The TIMEDATE function returns the current local date and time in the following format:

hh:mm:ss dd mmm yyyy

Time is represented on a 24-hour clock. Colons are used as the time separator. The date is represented as the number of days, the three-letter abbreviation for the month, and the year. Spaces are used as the date separator.


You can specify the default date format using Caché NLS. Because of operational differences between MV and Caché NLS in the handling of month names, your NLS default date format must represent months as integers.

TIMEDATE does not return fractional seconds. It truncates fractional seconds. To return the local time with fractional seconds, use the TIME function or the SYSTEM(12) function.

Caché MultiValue determines local time (and date) as follows:

  • It determines the current Coordinated Universal Time (UTC) from the system clock.

  • It adjusts UTC to the local time zone by using the value of the Caché special variable $ZTIMEZONE.

  • It applies local time variant settings (such as Daylight Saving Time) for that time zone from the host operating system.

See Also

FeedbackOpens in a new tab