C Data Type Definition
typedef long int DATE;
Usage
The date is represented using the following formula:
((year-1900) x 10000 + (month x 100) + day)
Here is an example using DATE in a UDF definition and C function declaration.
| SQL Function Definition | Equivalent C Function Declaration |
|---|---|
CREATE FUNCTION F1 ( A DATE ) RETURNS DATE ...; |
void f1( DATE *a,
DATE *result,
... )
{ ... }
|