Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » UltraLite - Database Management and Reference » UltraLite SQL Function Reference » Alphabetical list of functions

DATEPART function [Date and time] Next Page

DATETIME function [Date and time]

Converts an expression into a timestamp.


DATETIME( expression )


expression    The expression to be converted. It is generally a string.


Attempts to convert numerical values return an error.

Standards and compatibility

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

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