e>

<p>A date shift is simply ignored if applied to a time value or visa versa.</p>

<p>Numbers specified in shift fields may contain a decimal point:</p>

<pre><code>    &#39;1.5&#39;       - 1 hour 30 minutes (time, date/time), or 1 day (date)
    &#39;2.5 0&#39;     - 2 days 12 hours (date/time), 12 hours (time) or
                  2 days (date)</code></pre>

<p>And to save typing, a zero is assumed for any missing numbers:</p>

<pre><code>    &#39;1::&#39;       - shift by 1 hour (time, date/time) or 1