Question-and-Answer Resource for the Building Energy Modeling Community

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

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

JoseRamon

57 ●1 ●3

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

__AmirRoth__

4436 ●5 ●17 http://bleedinggreenna...

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

add a comment

1 Answer

Sort by » oldest newest most voted

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

shorowit

10881 ●179 ●9 https://www.nrel.gov/b...

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

Comments

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 ( 2021-08-30 18:18:10 -0500 )edit

add a comment

Your Answer

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

Add Answer

Careers

Question Tools

2 followers

Stats

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

Seen: 153 times

Last updated: Aug 31 '21

Site design and logo: Copyright © 2015 Big Ladder Software LLC. All rights reserved.
The Unmet Hours and Big Ladder names and logos are trademarks of Big Ladder Software LLC.
User contributions licensed under the Creative Commons Attribution Share Alike 3.0 License.

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