Contents Index YEARS function [Date and time] SQL Statements

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 
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 )

Contents Index YEARS function [Date and time] SQL Statements