First time here? Check out the Help page!

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

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

asked 3 years ago

JoseRamon's avatar

updated 3 years ago

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

Preview: (hide)

1 Answer

Sort by » oldest newest most voted
4

answered 3 years ago

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.

Preview: (hide)
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's avatar JoseRamon  ( 3 years ago )

Your Answer

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

Add Answer

Training Workshops

Careers

Question Tools

2 followers

Stats

Asked: 3 years ago

Seen: 167 times

Last updated: Aug 31 '21