Difference between revisions of "UTC"

From MythTV Official Wiki
Jump to: navigation, search
m (Typo)
(Link to MySQL_Time_Zone_Table)
(One intermediate revision by one user 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.
Beginning with the 0.26 release, most MythTV internal times are stored in UTC.
 
  
The following lists the tables and columns that were changed from local time
+
The 0.26 release of MythTV convertes database columns related to scheduled recordings
to UTC by the 0.26 database upgrade process.
+
from local time to UTC. See [[MySQL_Time_Zone_Tables|MySQL Time Zone Tables]]
 
+
<br>&nbsp;
{| border="1" cellspacing="0" cellpadding="5" style="float: left; border-collapse:collapse; border-color:#8eabd0; background:#e7edf5"
+
<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, recordedupdate
+
|oldrecorded, program, recordedprogram
 
|starttime, endtime
 
|starttime, endtime
 
|-
 
|-
|record, recorded
+
|record
 
|startdate, starttime, enddate, endtime
 
|startdate, starttime, enddate, endtime
 
|-
 
|-
|recordedfilter
+
|recorded
 +
|startdate, starttime, progstart, progend
 +
|-
 +
|recordfilter
 
|clause (for filterid 3 only)
 
|clause (for filterid 3 only)
 
|-
 
|-
 
|}
 
|}
 
+
<!--
 +
<br>&nbsp;
 +
{| 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>&nbsp;
 
[[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
 

Converted From Local Time to UTC
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)