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:


Top of page

x
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.



Example: Converting to a Date

DATE converts a value to a date. This example,

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

returns 19990329.


iWay Software