GETTIMESTAMP

Description:

This function returns the number of milliseconds since January 1, 1970, 00:00:00 GMT represented by this given date.

Syntax:

GETTIMESTAMP(Scalar_Expression)

Return Type:

SCALAR

Parameters:

Parameter	Description

Parameter	Description
Scalar_Expression	A date scalar value which is a date datatype type.

Example:

WITH MEMBER [Measures].[Query Timestamp] AS
    GetTimestamp()
SELECT 
    {[Measures].[Internet Sales Amount], [Measures].[Query Timestamp]} ON COLUMNS
FROM [AdventureWorksMF_ValueBased]