date()

Read(974) Label: string, integer, date value,

Description:

Convert a string or an 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 into 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.

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

Integer

month

Integer

day

Integer

ym

6-bit integer interpreted as year and month

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

Related function:

date(datetimeExp)

datetime(datetimeExp)

time(datetimeExp)

datetime()

time()