Welcome to rosterme.com.au/Internals
For full documentation on using this markup tool - visit mkdocs.org.
Commands
mkdocs new [dir-name]
- Create a new project.
mkdocs serve
- Start the live-reloading docs server.
mkdocs build
- Build the documentation site.
mkdocs help
- Print this help message.
Project layout
mkdocs.yml # The configuration file.
docs/
index.md # The documentation homepage.
... # Other markdown pages, images and other files.
Format |
Example |
Date only |
TIMESTAMP '2016-01-25' |
Date and Time |
TIMESTAMP '2016-01-25 10:10:10.555555' |
ISO 8601 |
TIMESTAMP '2016-01-25T10:10:10.555555' |
Examples
> CREATE TABLE timestamps (a INT PRIMARY KEY, b TIMESTAMPTZ);
> SHOW COLUMNS FROM timestamps;
+-------+--------------------------+-------+---------+
| Field | Type | Null | Default |
+-------+--------------------------+-------+---------+
| a | INT | false | NULL |
| b | TIMESTAMP WITH TIME ZONE | true | NULL |
+-------+--------------------------+-------+---------+
> INSERT INTO timestamps VALUES (1, TIMESTAMPTZ '2016-03-26 10:10:10-05:00'), (2, TIMESTAMPTZ '2016-03-26');
> SELECT * FROM timestamps;
+---+---------------------------+
| a | b |
+---+---------------------------+
| 1 | 2016-03-26 15:10:10+00:00 |
| 2 | 2016-03-26 00:00:00+00:00 |
+---+---------------------------+
Supported Casting & Conversion
Type |
Details |
INT |
Converts to number of seconds since the Unix epoch (Jan. 1, 1970) |
SERIAL |
Converts to number of seconds since the Unix epoch (Jan. 1, 1970) |
DECIMAL |
Converts to number of seconds since the Unix epoch (Jan. 1, 1970) |
FLOAT |
Converts to number of seconds since the Unix epoch (Jan. 1, 1970) |
TIME |
New in v2.0: Converts to the time portion (HH:MM:SS) of the timestamp |
DATE |
–– |
STRING |
–– |