How to convert ISO 8601 DateTime format into DateTime format using TERR.

How to convert ISO 8601 DateTime format into DateTime format using TERR.

book

Article ID: KB0075383

calendar_today

Updated On:

Products Versions
Spotfire Enterprise Runtime for R All Versions

Description

This article explains how we can convert the string version of the ISO 8601 DateTime format into DateTime format using TIBCO Enterprise Runtime for R(TERR) function.

Example of ISO 8601 DateTime format: 2020-05-11T23:41:09+00:00

Issue/Introduction

How to convert ISO 8601 DateTime format into DateTime format using TERR.

Environment

All Supported OS

Resolution

You can achieve this by following below steps:

- Install parsedate package from CRAN and use the parse_iso_8601() function.

For example:
library(parsedate)
x <- "2020-05-11T23:41:09+00:00"
result <- data.frame(dateCol=parse_iso_8601(x))

 

Additional Information

You can refer below web link to know more about parse_iso_8601()function:

https://www.r-project.org/nosvn/pandoc/parsedate.html