ASA SQL Reference

SQL Functions

Alphabetical list of functions

YMD function [Date and time]

Function 

Returns a date value corresponding to the given year, month, and day of the month. Values are small integers from -32768 to 32767.

Syntax 

YMD (
integer-expression,
integer-expression,
integer-expression )

Parameters 

integer-expression    The year.

integer-expression    The number of the month. If the month is outside the range 1–12, the year is adjusted accordingly.

integer-expression    The day number. The day is allowed to be any integer, the date is adjusted accordingly.

Standards and compatibility 

• SQL/92    Vendor extension.

• SQL/99    Vendor extension.

• Sybase    Compatible with Adaptive Server Enterprise

Example 

The following statement returns the value 1998-06-12.

SELECT YMD( 1998, 06, 12 )

If the values are outside their normal range, the date will adjust accordingly. For example, the following statement returns the value 2000-03-01.

SELECT YMD( 1999, 15, 1 )

SQL Anywhere Studio 9.0.1
Copyright © 1989–2004 Sybase, Inc. Portions copyright © 2001–2004 iAnywhere Solutions, Inc. All rights reserved.