Marek at 11:42, 17 July 2012

2012-07-17T11:42:30Z

Marek: Created page with "Date and time types.

schema:scott

The SQL standard permits three types. DATE, TIME and TIMESTAMP. A TIMESTAMP includes a date an..."

2012-07-17T11:41:44Z

Created page with "Date and time types. <div class='ht'> <div class=params>schema:scott</div> <div> The SQL standard permits three types. DATE, TIME and TIMESTAMP. A TIMESTAMP includes a date an..."

New page

Date and time types.
<div class='ht'>
<div class=params>schema:scott</div>
<div>
The SQL standard permits three types. DATE, TIME and TIMESTAMP.
A TIMESTAMP includes a date and a time.
Several engines use the word TIMESTAMP for a different purpose.
</div>

<source lang=sql class='tidy'>DROP TABLE t_dttest</source>
<source lang=sql class='setup'>CREATE TABLE t_peep
(id INTEGER PRIMARY KEY
,name VARCHAR(50))</source>

<source lang='sql' class='def e-oracle'>CREATE TABLE t_dttest(
a DATE,
c TIMESTAMP);

INSERT INTO t_dttest VALUES (
DATE '1962-05-20',
TIMESTAMP '1962-05-20 10:32:16');

SELECT * FROM t_dttest;
</source>
<source lang='sql' class='def e-db2 e-access e-sqlite'>CREATE TABLE t_dttest(
a DATE,
b TIME,
c TIMESTAMP);

INSERT INTO t_dttest VALUES (
'1962-05-20',
'10:32:16',
'1962-05-20 10:32:16');

SELECT * FROM t_dttest;
</source>
<source lang='sql' class='def e-sqlserver'>CREATE TABLE t_dttest(
a DATETIME,
b DATETIME,
c DATETIME);

INSERT INTO t_dttest VALUES (
'1962-05-20',
'10:32:16',
'1962-05-20 10:32:16');

SELECT * FROM t_dttest;
</source>
<source lang='sql' class='def e-sybase'>CREATE TABLE t_dttest(
a DATE,
b TIME,
c DATETIME);

INSERT INTO t_dttest VALUES (
'1962-05-20',
'10:32:16',
'1962-05-20 10:32:16');

SELECT * FROM t_dttest;
</source>
<source lang='sql' class='def'>CREATE TABLE t_dttest(
a DATE,
b TIME,
c DATETIME);

INSERT INTO t_dttest VALUES (
DATE '1962-05-20',
TIME '10:32:16',
TIMESTAMP '1962-05-20 10:32:16');

SELECT * FROM t_dttest;
</source>
<source lang='sql' class='def'>CREATE TABLE t_dttest(
a DATE,
b TIME,
c TIMESTAMP);

INSERT INTO t_dttest VALUES (
DATE '1962-05-20',
TIME '10:32:16',
TIMESTAMP '1962-05-20 10:32:16');

SELECT * FROM t_dttest;
</source>
<div class="ecomm e-mysql" style="display: none"></div>
</div>

{{DATE and TIME ref}}

@@ Line 59: / Line 59: @@
 SELECT * FROM t_dttest;
 </source>
-<source lang='sql' class='def'>CREATE TABLE t_dttest(
+<source lang='sql' class='def e-mysql'>CREATE TABLE t_dttest(
    a DATE,
    b TIME,

Date and time types - Revision history

Marek at 11:42, 17 July 2012

Marek: Created page with "Date and time types. schema:scott The SQL standard permits three types. DATE, TIME and TIMESTAMP. A TIMESTAMP includes a date an..."

Marek: Created page with "Date and time types.

schema:scott

The SQL standard permits three types. DATE, TIME and TIMESTAMP. A TIMESTAMP includes a date an..."