date()

date(stringExp,format:loc)

Convert stringExp to a date value according to the format defined by format and return null if the conversion fails; parameter loc is the language used in stringExp; the default is the system language.

date(stringExp)

The format of the result returned by stringExp should be in consistent with the date format in configuration information; if time is contained in the result, the time will not be converted; return null if the conversion fails.

date(year,month,day)

Convert year, month, day of integer type to date type; return null if the conversion fails.

date(ym,day)

Convert integer ym and day to date data.

date(ymd)

Convert integer ymd to date data.

date@o(day)

Convert integer type day to date type data; parameter day can be regarded as the value of computing days@o()

format

Format string.

stringExp

String expression.

loc

Language name, which is case insensitive. The most commonly used languages are Chinese (zh) and English (en); see A.sort() to know other languages supported in esProc.

year

An integer.

month

An integer.

day

An integer.

ym

An integer, which is interpreted as year and month when it is a 6-bit one and where 20 is added at the beginning when it is a 4-bit one.

ymd

An 8-bit or 6-bit integer where month and day take up two bits respectively and year occupies two or four bits.

A

1

=date("1982-08-09")

1982-08-09

2

=date("1982-08-09 10:20:30")

1982-08-09

3

=date(1982,08,09)

1982-08-09

4

=date(1982,-8,09)

1981-04-09

5

=date(1982,18,09)

6/9/1983

6

=date("12/28/1972"," MM/dd/yyyy ")

1972-12-28

7

=date(189208,08)

1892-08-08

8

=date("4 Jul 2001","d MMM yyyy":"en")

2001-07-04

9

=date@o(150)

1970-05-22

10

=date(2504,08)

2025-04-08

11

=date(20250408)

2025-04-08

12

=date(250408)

2025-04-08