HomePage esProc Function Reference date() date() ＜Previous |

date()

Read（2014） Label: string, integer, date value,

Description:

Convert a string, an integer or a long integer to a date value.

Syntax:

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()

Note:

The function converts string stringExp or integer year, month, day to date type data.

 

The date format in the conversion result should be consistent with the date format specified in the configuration file. Click Options -> Environment -> Date Format in IDE to perform the settings. When esProc is integrated into a third-party application, set up the date format in raqsoftConfig.xml’s dateFormat node.

Parameter:

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.

Return value:

Date

Example:

 

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

Related function:

date(datetimeExp)

datetime(datetimeExp)

time(datetimeExp)

datetime()

time()