DATE: Converting to a Date

How to:

The DATE function converts its argument to a date. The type of the argument value may be character, date, or timestamp.

If the argument is:

A character, its value must correctly represent a date; that date is the result.
A date, its value is returned.
A timestamp, the date portion of the timestamp value is returned.

Syntax: How to Convert to a Date

DATE(arg)

where:

arg

character string, date, or timestamp

Is the value to be converted.

The DATE function returns a date in YYMD format.

DATE converts a value to a date. This example,

DATE('1999-03-29 14:39:30')

returns 19990329.

	WebFOCUS