Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Table plus
applyColStyleToCelltrue
heading0
columnTypess,s,s,s
heading0
multiplefalse
columnAttributesstyle="background:#e5e7ea;font-weight:bold,,style="background:#e5e7ea;font-weight:bold,
enableSortingfalse

Syntax

toDate(year, month, day[, hour, minute, second[, millis[, timeZone]]])

Package

Alias

toDate(year, month, day[, hour, minute, second[, millis]])

Pkg Usage

Description

Excerpt
hiddentrue

Creates a date value from the specified parameters.

Creates a date value from the specified parameters.

...

Table plus
applyColStyleToCelltrue
columnTypess,s,s,s
heading0
multiplefalse
enableSortingfalse

Parameter name

Type

Required

Description

year

Number

Yes

Specifies the year value.

month

Number

Yes

Specifies the month value. This value is 1-based (e.g 1 = January, 12 = December). Accepted values are [1-12].

day

Number

Yes

Specifies the day of month value. Providing an invalid day value for the specified month/year (e.g. 30 Feb 2013, 29 Feb 2013) will throw an exception at runtime. Accepted values are [1-28-29-30-31].

hour

Number

No

Specifies the hour of day value. Accepted values are [0-23].

minute

Number

No

Specifies the minutes value. Accepted values are [0-59].

second

Number

No

Specifies the number of seconds. Accepted values are [0-59].

millis

Number

No

Specifies the number of milliseconds. Accepted values are [0-999].

timeZone

String

No

Specifies the time zone using a format compatible with TimeZone. See TimeZone for more details.

Return Type

Date

Example

Code Block
languagejs
function toDate7Descr(number year, number month, number day, number hour, number minute, number second, string timeZone) { 
  string format = "dd-MMM-yyyy HH:mm:ss Z"; 
  desc += "Converted year " + year + ", month " + month + ", day " + day + ", hour " + hour + ", minute " + minute + ", second " + second + ", timeZone " + timeZone; 
  desc += " to date " + formatDate(toDate(year, month, day, hour, minute, second, 0, timeZone), format) + "\n"; 
}
function toDate6Descr(number year, number month, number day, number hour, number minute, number second){
 desc += "Converted year " + year + ", month " + month + ", day " + day + ", hour " + hour + ", minute " + minute + ", second " + second;
 desc += " to date " + toDate(year, month, day, hour, minute, second) + "\n";
}
function toDate3Descr(number year, number month, number day){
 desc += "Converted year " + year + ", month " + month + ", day " + day;
 desc += " to date " + toDate(year, month, day) + "\n";
}
desc = "";
toDate3Descr(2013, 12, 31);
toDate3Descr(2013, 2, 28);
toDate3Descr(2012, 2, 29);
toDate3Descr(2013, 2, 29); 
toDate6Descr(2013, 12, 31, 23, 59, 59);
toDate6Descr(2013, 2, 28, 0, 0, 0);
toDate6Descr(2012, 2, 29, 14, 15, 16);
toDate6Descr(2013, 1, 1, 24, 1, 1);

toDate7Descr(2012, 01, 20, 0, 0, 0, "GMT+2");

...

Converted year 2012, month 1, day 20, hour 0, minute 0, second 0, timeZone GMT+2 to date 20-Jan-2012 00:00:00 +0200


Note

The created date will use the locale of the JVM. If any of the parameters are outside of the specified interval (e.g attempting to create 32 January), the routine will return an empty date, such that isNull(date) is "true".


See also

Filter by label (Content by label)
showLabelsfalse
max25
showSpacefalse
cqllabel = "date_routine" and space = currentSpace ( )
labelsarray_routines
We've encountered an issue exporting this macro. Please try exporting this page again later.