Question-and-Answer Resource for the Building Energy Modeling Community
Get started with the Help page
Ask Your Question

Is it possible to get time series date column in ISO8601 format from e+?

asked 2021-08-29 18:21:04 -0600

JoseRamon's avatar

updated 2022-02-08 09:08:42 -0600

Hi all,

I'm tinkering with e+ time series and relational dbs, and I was wondering if its possible to change the date format in the .csv files outputted from output:variable to ISO8601 format.

For example, changing date column values from 01/21 00:15:00 to 2018-01-21T00:15:21Z

Is there a way to get the date value in such format? Id appreciate any insights Thanks

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted

answered 2021-08-30 17:49:06 -0600

It's not currently possible to configure the date/time format that EnergyPlus uses, though it's a heavily requested feature. There is some discussion on adding more configurability in this GItHub issue. If you think the EnergyPlus team should prioritize this feature, give it a thumbs up.

In the meantime, the only possible solution is to use your programming language or application of choice to reformat the dates.

edit flag offensive delete link more


I see, thanks for the reply. I ended up reformatting the file. Hopefully that'll be possible soon, so time series conversion to RDBs can be simpler, I gave a thumbs up to the gh issue

JoseRamon's avatar JoseRamon  ( 2021-08-30 18:18:10 -0600 )edit

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer


Question Tools



Asked: 2021-08-29 18:21:04 -0600

Seen: 152 times

Last updated: Aug 31 '21