Difference between revisions of "UTC"

From MythTV Official Wiki
Jump to: navigation, search
m (Typo)
m (Spelling)
 
(2 intermediate revisions 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 converts 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]]

Latest revision as of 06:52, 19 September 2013

UTC is a time standard.

The 0.26 release of MythTV converts 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)