MVTIME()

The MVTIME() function returns the multivalue style time value (seconds since midnight) for a supplied epoch value using the currently selected time zone.

Format

MVTIME(epoch.value)

where

An epoch value represents a moment in time. The MVTIME() function returns the time part of this as relevant to the currently selected time zone.

 
Example

T = 1234567890

SET.TIMEZONE 'GMT'

DISPLAY MVTIME(T)

SET.TIMEZONE 'Pacific/Wake'

DISPLAY MVTIME(T)

The above program fragment displays

84690

41490

The times differ because this moment in time was 23:31:30 on 13 February 2009 in the GMT time zone but it was 11:31:30 on 14 February 2009 in the Pacific/Wake time zone.

See also:

Date, Times and Epoch Values, EPOCH(), MVDATE(), MVDATE.TIME(), MVEPOCH(), SET.TIMEZONE