DATENAME function [Date and time]

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

SAP Sybase SQL Anywhere 16.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

Example

Discuter à propos de cette page dans DocCommentXchange.

Copyright © 2013, SAP AG ou société affiliée SAP - SAP Sybase SQL Anywhere 16.0