ASA SQL Reference
  SQL Functions
    Alphabetical list of functions

DATETIME function [Date and time]

Function 

Converts an expression into a timestamp.

Syntax 

DATETIME ( expression )

Parameters 

expression    The expression to be converted. It is generally a string. Attempts to convert numerical values return an error.

Standards and compatibility 

• SQL/92    Vendor extension.

• SQL/99    Vendor extension.

• Sybase    Not supported by Adaptive Server Enterprise.

Example 

The following statement returns a timestamp with value 1998-09-09 12:12:12.000.

SELECT DATETIME( '1998-09-09 12:12:12.000' )