date()

Read(316) 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; 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

date(year,month,day)

Convert year,month,day of integer type to date type

date(ym,day)

Convert integer ym and day into date data

Note:

The function converts string stringExp or integer year,month,day 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

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

Related functions:

date(datetimeExp)

datetime(datetimeExp)

time(datetimeExp)

datetime()

time()