Which internal date format in RTC
Which the internal format of the information (START_DATE) of the table [MODEL]. [TIME_SHEET_ENTRY] the RTC.
How to turn on Julian date example of the information recorded in our database '1394452800000 ', what does mean this format? is possible to transform into Julian date (03/10/2014)?
Thanks
|
Accepted answer
The question is more like a database question in stead of RTC.
If you are using DB2, DB2 stores values of datetime data types in a special internal format. When you load or retrieve data, DB2 can convert it. Please refer to http://www.ibm.com/developerworks/data/library/techarticle/0211yip/0211yip3.html. If you are using other database vendor, I believe you can find similar information in other public forums. BTW, direct access and manipulation of database tables and their content is not recommended.It's recommended to access the data via java API or REST API. Cláudio de Sá Rodrigues selected this answer as the correct answer
|
One other answer
I'm pretty sure dates are stored as integers representing "milliseconds since epoch". 1394452800000 does indeed translate to 3/10/2014. Depending on what you're using to display the date (Excel?), there are certainly ways to convert it that can be found through a Google search.
I second Lily's suggestion of using one of the APIs to retrieve this data though. |
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.