Zmg6bEeh

1YYYY-MM-DD
2YYYY-MM-DD HH:MM
3YYYY-MM-DD HH:MM:SS
4YYYY-MM-DD HH:MM:SS.SSS
5YYYY-MM-DDTHH:MM
6YYYY-MM-DDTHH:MM:SS
7YYYY-MM-DDTHH:MM:SS.SSS
8HH:MM
9HH:MM:SS
10HH:MM:SS.SSS
11now
12DDDDDDDDDD
13	
142013-10-07 08:23:19.120
152013-10-07T08:23:19.120Z
162013-10-07 04:23:19.120-04:00
172456572.84952685
18	
19DROP TABLE IF EXISTS savetimestamps;
20CREATE TABLE IF NOT EXISTS savetimestamps (
21  name TEXT,
22    ts01 rumplestiltskin DEFAULT CURRENT_TIMESTAMP, 
23    ts02 INTEGER DEFAULT CURRENT_TIMESTAMP,
24    ts03 myreallybigintbutrealllyitisjustandint DEFAULT CURRENT_TIMESTAMP,
25    ts04 BLOB DEFAULT CURRENT_TIMESTAMP,
26    ts05 REAL DEFAULT CURRENT_TIMESTAMP
27);
28INSERT INTO savetimestamps (name) VALUES('A');
29INSERT INTO savetimestamps VALUES(1,'a',3.725,4,5,x'010203040506070809'); -- useless/confusing data
30SELECT *,
31    rowid AS id,
32    STRFTIME('%d %M %Y', ts01) AS t1,
33    STRFTIME('%d %M %Y', ts02, '-1 DAYS') AS t2,
34    STRFTIME('%d %M %Y', ts03, '-2 DAYS') AS t3,
35    STRFTIME('%d %M %Y', ts04, '-3 DAYS') AS t4,
36    STRFTIME('%d %M %Y', ts05, '-4 DAYS') AS t5
37FROM savetimestamps;
38SELECT
39    name,typeof(ts01),typeof(ts02),typeof(ts03),typeof(ts04),typeof(ts05)
40FROM savetimestamps;