DATESERIAL Function
Function Type | Predefined function | |
Syntax | DATESERIAL( <year>, <month>, <day> ) | |
Description | Constructs a date value from specified year, month, and day values. | |
Argument | Description | |
<year> | Integer representing the year portion of the date. Acceptable values for year are integers between -4700 to -1 and 1 to 25000, inclusive. Values for this argument are taken literally. Two-digit values cannot be used to specify years in the current century. | |
<month> | Integer representing the month portion of the date. The supported range of values for month are 1-12, inclusive. | |
<day> | Integer representing the day of month part of the date. Day range: 1-31. | |
Returns | Date | |
Example | This function returns 1997-05-14 00:00:00 DATESERIAL(1997,5,14) | |
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*