DATENAME function [Date and time]

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

SQL Anywhere 12.0.0 » UltraLite - Database Management and Reference » UltraLite SQL reference » UltraLite SQL functions » Functions

DATENAME function [Date and time]

Returns the name of the specified part (such as the month June) of a TIMESTAMP or TIMESTAMP WITH TIME ZONE value, as a character string.

Syntax

DATENAME( date-part, timestamp-expression )

Parameters

date-part The date part to be named.
For a complete listing of allowed date parts, see Specifying date parts.
timestamp-expression The TIMESTAMP or TIMESTAMP WITH TIME ZONE value for which the date part name is to be returned. For meaningful results, timestamp-expression should contain the requested date-part.

Returns

Remarks

See also

Standards and compatibility

Example

Discuss this page in DocCommentXchange.

Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0