DATETIME function [Date and time]

Function

Converts an expression into a timestamp.

Syntax

DATETIME ( expression )

Parameters

expression The expression to be converted. The expression is usually a string. Conversion errors may be reported.

Example

This statement:

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

returns a timestamp with value 1998-09-09 12:12:12.000:

Standards and compatibility

SQL92 Vendor extension.

Sybase Not supported by Adaptive Server Enterprise.