File: interval.expect.txt

package info (click to toggle)
highlight.js 10.7.3%2Bdfsg-2
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 8,332 kB
  • sloc: javascript: 41,059; makefile: 157; python: 29; sh: 20
file content (17 lines) | stat: -rw-r--r-- 2,416 bytes parent folder | download 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
 
<span class="hljs-keyword">SELECT</span> 
    <span class="hljs-keyword">CURRENT_TIMESTAMP</span> 
    - <span class="hljs-built_in">INTERVAL</span> <span class="hljs-number">2</span> <span class="hljs-keyword">YEARS</span> 
    + <span class="hljs-built_in">INTERVAL</span> <span class="hljs-number">1</span> <span class="hljs-keyword">MONTH</span> 
    - <span class="hljs-built_in">INTERVAL</span> <span class="hljs-number">3</span> <span class="hljs-keyword">DAYS</span> 
    + <span class="hljs-built_in">INTERVAL</span> <span class="hljs-number">10</span> <span class="hljs-keyword">HOURS</span> 
    + <span class="hljs-built_in">interval</span> <span class="hljs-number">30</span> <span class="hljs-keyword">MINUTES</span> 
    - <span class="hljs-built_in">INTERVAL</span> <span class="hljs-number">20</span> <span class="hljs-keyword">SECOND</span> <span class="hljs-keyword">AS</span> past_timestamp
<span class="hljs-keyword">FROM</span> <span class="hljs-keyword">VALUES</span> (<span class="hljs-string">&quot;dummy&quot;</span>);

<span class="hljs-keyword">WITH</span> ts <span class="hljs-keyword">AS</span> (
    <span class="hljs-keyword">SELECT</span> <span class="hljs-keyword">CURRENT_TIMESTAMP</span> <span class="hljs-keyword">AS</span> <span class="hljs-keyword">now</span> <span class="hljs-keyword">FROM</span> <span class="hljs-keyword">VALUES</span> (<span class="hljs-string">&#x27;dummy&#x27;</span>)
    ) 
<span class="hljs-keyword">SELECT</span> 
    <span class="hljs-keyword">now</span> - <span class="hljs-built_in">INTERVAL</span> <span class="hljs-number">1</span> <span class="hljs-keyword">DAY</span> - <span class="hljs-built_in">INTERVAL</span> <span class="hljs-number">2</span> <span class="hljs-keyword">HOURS</span> - <span class="hljs-built_in">INTERVAL</span> <span class="hljs-number">3</span> <span class="hljs-keyword">MINUTES</span> - <span class="hljs-built_in">INTERVAL</span> <span class="hljs-number">4</span> <span class="hljs-keyword">SECONDS</span> <span class="hljs-keyword">AS</span> LONG_VERSION, 
    <span class="hljs-keyword">now</span> - <span class="hljs-built_in">INTERVAL</span> <span class="hljs-string">&#x27;1 2:3:4.100&#x27;</span> <span class="hljs-keyword">DAY</span> <span class="hljs-keyword">TO</span> <span class="hljs-keyword">SECOND</span> <span class="hljs-keyword">AS</span> SHORT_VERSION
<span class="hljs-keyword">FROM</span> ts;