https://www.memcp.org/index.php?action=history&feed=atom&title=Timezone 2026-08-28T06:32:48Z Revision history for this page on the wiki MediaWiki 1.39.1 https://www.memcp.org/index.php?title=Timezone&diff=292&oldid=prev 2026-08-27T06:36:18Z

<p></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 08:36, 27 August 2026</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1">Line 1:</td> <td colspan="2" class="diff-lineno">Line 1:</td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">← Back to [[Full SCM API documentation]]</ins></div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== unix_timestamp ==</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== unix_timestamp ==</div></td></tr> <!-- diff cache key memcp_wiki-mediawiki-:diff::1.12:old-291:rev-292 --> </table>

Carli https://www.memcp.org/index.php?title=Timezone&diff=291&oldid=prev 2026-08-27T06:35:23Z

<p>Created page with &quot; == unix_timestamp == returns a unix timestamp (integer seconds since epoch) &#039;&#039;&#039;Allowed number of parameters:&#039;&#039;&#039; 0–1 &lt;span id=&quot;parameters&quot;&gt;&lt;/span&gt; === Parameters === * &#039;&#039;&#039;dt&#039;&#039;&#039; (&lt;code&gt;any&lt;/code&gt;): optional datetime value to convert &#039;&#039;(optional)&#039;&#039; &lt;span id=&quot;returns&quot;&gt;&lt;/span&gt; === Returns === &lt;code&gt;int&lt;/code&gt; == system_time_zone == returns the operating system&#039;s local timezone name &#039;&#039;&#039;Allowed number of parameters:&#039;&#039;&#039; 0–0 &lt;span id=&quot;parameters-1&quot;&gt;&lt;/span&gt; === Para...&quot;</p> <p><b>New page</b></p><div><br /> == unix_timestamp ==<br /> <br /> returns a unix timestamp (integer seconds since epoch)<br /> <br /> &#039;&#039;&#039;Allowed number of parameters:&#039;&#039;&#039; 0–1<br /> <br /> &lt;span id=&quot;parameters&quot;&gt;&lt;/span&gt;<br /> === Parameters ===<br /> <br /> * &#039;&#039;&#039;dt&#039;&#039;&#039; (&lt;code&gt;any&lt;/code&gt;): optional datetime value to convert &#039;&#039;(optional)&#039;&#039;<br /> <br /> &lt;span id=&quot;returns&quot;&gt;&lt;/span&gt;<br /> === Returns ===<br /> <br /> &lt;code&gt;int&lt;/code&gt;<br /> <br /> == system_time_zone ==<br /> <br /> returns the operating system&#039;s local timezone name<br /> <br /> &#039;&#039;&#039;Allowed number of parameters:&#039;&#039;&#039; 0–0<br /> <br /> &lt;span id=&quot;parameters-1&quot;&gt;&lt;/span&gt;<br /> === Parameters ===<br /> <br /> &#039;&#039;This function has no parameters.&#039;&#039;<br /> <br /> &lt;span id=&quot;returns-1&quot;&gt;&lt;/span&gt;<br /> === Returns ===<br /> <br /> &lt;code&gt;string&lt;/code&gt;<br /> <br /> == convert_tz ==<br /> <br /> converts a datetime from one timezone to another<br /> <br /> &#039;&#039;&#039;Allowed number of parameters:&#039;&#039;&#039; 3–3<br /> <br /> &lt;span id=&quot;parameters-2&quot;&gt;&lt;/span&gt;<br /> === Parameters ===<br /> <br /> * &#039;&#039;&#039;dt&#039;&#039;&#039; (&lt;code&gt;any&lt;/code&gt;): datetime value<br /> * &#039;&#039;&#039;from_tz&#039;&#039;&#039; (&lt;code&gt;string&lt;/code&gt;): source timezone<br /> * &#039;&#039;&#039;to_tz&#039;&#039;&#039; (&lt;code&gt;string&lt;/code&gt;): target timezone<br /> <br /> &lt;span id=&quot;returns-2&quot;&gt;&lt;/span&gt;<br /> === Returns ===<br /> <br /> &lt;code&gt;date&lt;/code&gt;<br /> <br /> == from_unixtime ==<br /> <br /> converts a unix timestamp to a datetime in the session timezone<br /> <br /> &#039;&#039;&#039;Allowed number of parameters:&#039;&#039;&#039; 1–2<br /> <br /> &lt;span id=&quot;parameters-3&quot;&gt;&lt;/span&gt;<br /> === Parameters ===<br /> <br /> * &#039;&#039;&#039;unix_ts&#039;&#039;&#039; (&lt;code&gt;number&lt;/code&gt;): unix timestamp (seconds since epoch)<br /> * &#039;&#039;&#039;format&#039;&#039;&#039; (&lt;code&gt;string&lt;/code&gt;): optional MySQL format string &#039;&#039;(optional)&#039;&#039;<br /> <br /> &lt;span id=&quot;returns-3&quot;&gt;&lt;/span&gt;<br /> === Returns ===<br /> <br /> &lt;code&gt;date&lt;/code&gt;<br /> <br /> == utc_timestamp ==<br /> <br /> returns the current UTC datetime<br /> <br /> &#039;&#039;&#039;Allowed number of parameters:&#039;&#039;&#039; 0–0<br /> <br /> &lt;span id=&quot;parameters-4&quot;&gt;&lt;/span&gt;<br /> === Parameters ===<br /> <br /> &#039;&#039;This function has no parameters.&#039;&#039;<br /> <br /> &lt;span id=&quot;returns-4&quot;&gt;&lt;/span&gt;<br /> === Returns ===<br /> <br /> &lt;code&gt;date&lt;/code&gt;<br /> <br /> == utc_date ==<br /> <br /> returns the current UTC date (midnight)<br /> <br /> &#039;&#039;&#039;Allowed number of parameters:&#039;&#039;&#039; 0–0<br /> <br /> &lt;span id=&quot;parameters-5&quot;&gt;&lt;/span&gt;<br /> === Parameters ===<br /> <br /> &#039;&#039;This function has no parameters.&#039;&#039;<br /> <br /> &lt;span id=&quot;returns-5&quot;&gt;&lt;/span&gt;<br /> === Returns ===<br /> <br /> &lt;code&gt;date&lt;/code&gt;<br /> <br /> == utc_time ==<br /> <br /> returns the current UTC time (as a datetime at epoch date)<br /> <br /> &#039;&#039;&#039;Allowed number of parameters:&#039;&#039;&#039; 0–0<br /> <br /> &lt;span id=&quot;parameters-6&quot;&gt;&lt;/span&gt;<br /> === Parameters ===<br /> <br /> &#039;&#039;This function has no parameters.&#039;&#039;<br /> <br /> &lt;span id=&quot;returns-6&quot;&gt;&lt;/span&gt;<br /> === Returns ===<br /> <br /> &lt;code&gt;date&lt;/code&gt;<br /> <br /> == sysdate ==<br /> <br /> returns the current datetime (re-evaluated per call, unlike now())<br /> <br /> &#039;&#039;&#039;Allowed number of parameters:&#039;&#039;&#039; 0–0<br /> <br /> &lt;span id=&quot;parameters-7&quot;&gt;&lt;/span&gt;<br /> === Parameters ===<br /> <br /> &#039;&#039;This function has no parameters.&#039;&#039;<br /> <br /> &lt;span id=&quot;returns-7&quot;&gt;&lt;/span&gt;<br /> === Returns ===<br /> <br /> &lt;code&gt;date&lt;/code&gt;<br /> <br /> == at_time_zone ==<br /> <br /> PostgreSQL AT TIME ZONE operator: converts between timezones<br /> <br /> &#039;&#039;&#039;Allowed number of parameters:&#039;&#039;&#039; 2–2<br /> <br /> &lt;span id=&quot;parameters-8&quot;&gt;&lt;/span&gt;<br /> === Parameters ===<br /> <br /> * &#039;&#039;&#039;dt&#039;&#039;&#039; (&lt;code&gt;any&lt;/code&gt;): datetime value<br /> * &#039;&#039;&#039;zone&#039;&#039;&#039; (&lt;code&gt;string&lt;/code&gt;): target timezone<br /> <br /> &lt;span id=&quot;returns-8&quot;&gt;&lt;/span&gt;<br /> === Returns ===<br /> <br /> &lt;code&gt;date&lt;/code&gt;<br /> <br /> == timestampdiff ==<br /> <br /> returns the difference between two datetimes in the given unit<br /> <br /> &#039;&#039;&#039;Allowed number of parameters:&#039;&#039;&#039; 3–3<br /> <br /> &lt;span id=&quot;parameters-9&quot;&gt;&lt;/span&gt;<br /> === Parameters ===<br /> <br /> * &#039;&#039;&#039;unit&#039;&#039;&#039; (&lt;code&gt;string&lt;/code&gt;): SECOND, MINUTE, HOUR, DAY, WEEK, MONTH, YEAR<br /> * &#039;&#039;&#039;dt1&#039;&#039;&#039; (&lt;code&gt;any&lt;/code&gt;): first datetime<br /> * &#039;&#039;&#039;dt2&#039;&#039;&#039; (&lt;code&gt;any&lt;/code&gt;): second datetime<br /> <br /> &lt;span id=&quot;returns-9&quot;&gt;&lt;/span&gt;<br /> === Returns ===<br /> <br /> &lt;code&gt;int&lt;/code&gt;</div>

Carli