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

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

JoseRamon

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

4.4k

__AmirRoth__

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

edit flag offensive 0 remove flag close merge delete

Comments

add a comment see more comments

1 Answer

Sort by

oldest

newest

most voted

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.

11.8k

shorowit

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

edit flag offensive 0 remove flag 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