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

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

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

Standards and compatibility

SQL Vendor extension to ISO/ANSI SQL grammar.

Sybase Not supported by Adaptive Server Enterprise