date()

Read(509) 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 into date data

date(longExp)

Convert long integer longExp to date type data

Note:

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

Parameters:

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

longExp

64-bit loing integer

Return value:

Date type data

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

1995-02-08

Related functions:

date(datetimeExp)

datetime(datetimeExp)

time(datetimeExp)

datetime()

time()