Skip to content

Instantly share code, notes, and snippets.

@mtgto

mtgto/New_Query.sql

Created July 22, 2020 16:33
Show Gist options
  • Save mtgto/6a81664ae771129bf9abf1d9ab2a8fae to your computer and use it in GitHub Desktop.
Save mtgto/6a81664ae771129bf9abf1d9ab2a8fae to your computer and use it in GitHub Desktop.
Download ZIP
New Query
Raw
New_Query.sql
select *
from (
values
(timestamptz '2020-07-22 09:00:00 UTC', 3)
, (timestamptz '2020-07-22 10:00:00 UTC', 1)
, (timestamptz '2020-07-22 08:00:00 UTC', 2)
) as t (time, value)
;
Display the source blob
Display the rendered blob
Raw
New_Query_01.svg
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
Raw
New_Query_02.tsv
time value
2020-07-22 18:00:00+09 3
2020-07-22 19:00:00+09 1
2020-07-22 17:00:00+09 2
Raw
New_Query_03.md

Data source

key value
type postgres
host localhost
port 5432
user user
database postgres

Created by

Bdash

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment