Difference between revisions of "UTC"

From MythTV Official Wiki
Jump to: navigation, search
m (Typo)
(Corrections)
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.
 
+
<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:20, 13 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.
 

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)