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  
 
 __AmirRoth__'s avatar  
 
 
 
 
 
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)
 
 
 
 
          
 
add a comment
 
 
 
 
 
 1 Answer
    
 
 
                    Sort by »
                     oldest newest most voted 
 
 
 
 
 
  
 
 
 
 
4
 
 
  
 
 
 
 
 
 
 
 
    
        
        answered 3 years ago  
 
 shorowit's avatar  
 
 
 
 
 
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
    )
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
 
 
 
 
 
 
 
 
   
  
 
   
 
 
 
 
 
 
 
Training Workshops
   
Careers
   
 
 
 
Question Tools
  
 

        
        
            2 followers
        
    
 
 
 subscribe to rss feed 
 
 
 
 
 
 
Stats
 

        Asked:  3 years ago  
 
 
        Seen: 167 times 
 

        Last updated: Aug 31 '21 
 
 
 
 
 
 
 
 
 
 About | Help |  Privacy | Legal | Contact 
 

        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.
         
 
 
 

        Powered by