MVTIME()

MVTIME()

Top  Previous  Next

 

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

 

epoch.valueis the epoch value to be converted.

 

 

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