Navigation:  »No topics above this level«

DATE(), CURDATE()

Advantage Concepts

Return to chapter overview

Scalar function that returns the system date as a date value.

Supported in SQL:

Yes

Supported in Navigational:

Yes

Syntax

DATE() à dSystem

CURDATE() à dSystem           (SQL Only)

CURRENT_DATE() à dSystem       (SQL Only)

 

Return Values

DATE() returns the system date as a date value.

Remarks

DATE() is a date function that provides a means of initializing memory variables to the current date, comparing other date values to the current date, and performing date arithmetic relative to the current date.

The display format for dates is controlled by the function to set the date format. The default format is mm/dd/yy in navigational usage.  In SQL usage, the standard format is yyyy-mm-dd.

See Also

CTOD()

DTOC()

DTOS()

NOW()

STOD()

STOTS()

TSTOD()

Advantage TDataSet Descendant

TAdsSettings.DateFormat

Advantage Client Engine API

AdsSetDateFormat