Time and Date Functions
      Back to home
      1. Datagration Knowledge Base
      2. P#
      3. Time and Date Functions

      ToDateTime

      Converts specified expression value to date/time value

      Converts specified expression value to date/time value
      Syntax
      ToDateTime(double doubleExpression)

      Example

      ToDateTime(Random())

       

      Converts specified date/time expression value to date/time value.

      Syntax
      ToDateTime(date/time dateTimeExpression)

      Example

      ToDateTime(Now())

       

      Converts specified date/time value to date/time value (no actual conversion).

      Syntax
      ToDateTime(date/time dateTimeValue)

      Example 

      ToDateTime(#1/1/2000#)

       

      Converts specified string expression value to date/time value, returns current date/time if conversion fails.

      Syntax
      ToDateTime(string stringExpression)

      Example

      ToDateTime("Well Test Date")