MVDATE.TIME()

MVDATE.TIME()

Top  Previous  Next

 

The MVDATE.TIME() function returns the multivalue style date and time values (days since 31 December 1967 and seconds since midnight) for a supplied epoch value using the currently selected time zone.

 

 

Format

 

MVDATE.TIME(epoch.value)

 

where

 

epoch.valueis the epoch value to be converted.

 

 

An epoch value represents a moment in time. The MVDATE.TIME() function returns the date and time parts of this as relevant to the currently selected time zone. The two parts are separated by an underscore.

 

 
Example

 

T = 1234567890

SET.TIMEZONE 'GMT'

DISPLAY MVDATE.TIME(T)

SET.TIMEZONE 'Pacific/Wake'

DISPLAY MVDATE.TIME(T)

 

The above program fragment displays

15020_84690

15021_41490

 

The dates 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(), MVEPOCH(), MVTIME(), SET.TIMEZONE