Difference between revisions of "UTC"
From MythTV Official Wiki
(UTC Glossary with 0.26 table changes) |
(Link to MySQL_Time_Zone_Table) |
||
| (2 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
[http://en.wikipedia.org/wiki/Coordinated_Universal_Time UTC] is a time standard. | [http://en.wikipedia.org/wiki/Coordinated_Universal_Time UTC] is a time standard. | ||
| − | |||
| − | The | + | The 0.26 release of MythTV convertes database columns related to scheduled recordings |
| − | to UTC | + | from local time to UTC. See [[MySQL_Time_Zone_Tables|MySQL Time Zone Tables]] |
| − | + | <br> | |
| − | {| border="1" cellspacing="0" cellpadding="5" style=" | + | <center> |
| + | {| border="1" cellspacing="0" cellpadding="5" style="border-collapse:collapse; border-color:#8eabd0; background:#e7edf5" | ||
|- style="background-color: lightsteelblue;" | |- style="background-color: lightsteelblue;" | ||
| + | |+ Converted From Local Time to UTC | ||
! scope="col" | Table(s) | ! scope="col" | Table(s) | ||
! scope="col" | Column(s) | ! scope="col" | Column(s) | ||
| Line 16: | Line 17: | ||
|airdate | |airdate | ||
|- | |- | ||
| − | |oldrecorded, program, recordedprogram | + | |oldrecorded, program, recordedprogram |
|starttime, endtime | |starttime, endtime | ||
|- | |- | ||
| − | |record | + | |record |
|startdate, starttime, enddate, endtime | |startdate, starttime, enddate, endtime | ||
|- | |- | ||
| − | | | + | |recorded |
| + | |startdate, starttime, progstart, progend | ||
| + | |- | ||
| + | |recordfilter | ||
|clause (for filterid 3 only) | |clause (for filterid 3 only) | ||
|- | |- | ||
|} | |} | ||
| − | + | <!-- | |
| + | <br> | ||
| + | {| border="1" cellspacing="0" cellpadding="5" style="border-collapse:collapse; border-color:#8eabd0; background:#e7edf5" | ||
| + | |- style="background-color: lightsteelblue;" | ||
| + | |+ Not Converted | ||
| + | ! scope="col" | Table(s) | ||
| + | ! scope="col" | Column(s) | ||
| + | |- | ||
| + | |channel | ||
| + | |last_record | ||
| + | |- | ||
| + | |channelscan | ||
| + | |scandate | ||
| + | |- | ||
| + | |housekeeping | ||
| + | |lastrun | ||
| + | |- | ||
| + | |internetcontent | ||
| + | |updated | ||
| + | |- | ||
| + | |internetcontentarticles | ||
| + | |date | ||
| + | |- | ||
| + | |inuseprograms | ||
| + | |starttime, lastupdatetime | ||
| + | |- | ||
| + | |jobqueue | ||
| + | |inserttime, schedruntime | ||
| + | |- | ||
| + | |livestream | ||
| + | |created, lastmodified | ||
| + | |- | ||
| + | |logging | ||
| + | |msgtime | ||
| + | |- | ||
| + | |music_songs | ||
| + | |lastplay, date_entered, date_modified | ||
| + | |- | ||
| + | |mythlog | ||
| + | |logdate | ||
| + | |- | ||
| + | |program, recorded, recordedprogram | ||
| + | |originalairdate | ||
| + | |- | ||
| + | |record | ||
| + | |next_record, last_record, last_delete | ||
| + | |- | ||
| + | |recordedfile, recordmatch | ||
| + | |starttime | ||
| + | |- | ||
| + | |tvchain | ||
| + | |starttime, endtime | ||
| + | |- | ||
| + | |videocollection, videometadata | ||
| + | |releasedate | ||
| + | |- | ||
| + | |} | ||
| + | --> | ||
| + | </center> | ||
| + | <br> | ||
[[Category:Glossary]] | [[Category:Glossary]] | ||
Revision as of 23:24, 15 September 2012
UTC is a time standard.
The 0.26 release of MythTV convertes database columns related to scheduled recordings
from local time to UTC. See MySQL Time Zone Tables
| Table(s) | Column(s) |
|---|---|
| credits, jobqueue, programgenres, programrating, recordedseek, recordedmarkup, recordedrating, recordedcredits | starttime |
| oldprogram | airdate |
| oldrecorded, program, recordedprogram | starttime, endtime |
| record | startdate, starttime, enddate, endtime |
| recorded | startdate, starttime, progstart, progend |
| recordfilter | clause (for filterid 3 only) |
