...
| Table plus |
|---|
| applyColStyleToCell | true |
|---|
| columnTypes | s,s,s,s |
|---|
| heading | 0 |
|---|
| multiple | false |
|---|
| columnAttributes | style="background:#e5e7ea;font-weight:bold,,style="background:#e5e7ea;font-weight:bold, |
|---|
| enableSorting | false |
|---|
|
Syntax | toTimeZone(date, timeZone) | Package | | Alias | | Pkg Usage | |
|
Description
| Excerpt |
|---|
|
Converts a date to the specified time zone. |
Converts a date to the specified time zone.
Parameters
| Table plus |
|---|
| applyColStyleToCell | true |
|---|
| columnTypes | s,s,s,s |
|---|
| heading | 0 |
|---|
| multiple | false |
|---|
| enableSorting | false |
|---|
|
Parameter name | Type | Required | Description |
|---|
date | Date | Yes | Specifies the date to convert. | timeZone | String | No | Specifies the time zone using a format compatible with TimeZone. See TimeZone for more details. |
|
Return Type
Date
Example
| Code Block |
|---|
|
desc = "";
date d = toDate(2012, 01, 20, 0, 0, 0, 0, "GMT-8");
string format = "dd-MMM-yyyy HH:mm:ss Z";
desc += formatDate(d, format) + " converted to " + formatDate(toTimeZone(d, "GMT+2"), format); |
Outputs to description: 20-Jan-2012 00:00:00 -0800 converted to 20-Jan-2012 10:00:00 +0200
See also
| Filter by label (Content by label) |
|---|
| showLabels | false |
|---|
| max | 25 |
|---|
| showSpace | false |
|---|
| cql | label = "date_routine" and space = currentSpace ( ) |
|---|
| labels | array_routines |
|---|
|
We've encountered an issue exporting this macro. Please try exporting this page again later.