MVDATE()

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

Format

MVDATE(epoch.value)

where

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

 
Example

T = 1234567890

SET.TIMEZONE 'GMT'

DISPLAY MVDATE(T)

SET.TIMEZONE 'Pacific/Wake'

DISPLAY MVDATE(T)

The above program fragment displays

15020

15021

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