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

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

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

JoseRamon gravatar image

updated 2021-08-30 09:37:32 -0500

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
3

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

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

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

2 followers

Stats

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

Seen: 62 times

Last updated: Aug 31