#1

CREATE TABLE
IF NOT EXISTS datetime_text (d1 text, d2 text);

#2

DATETIME('now');

#3

DATETIME('now','localtime');

#4

INSERT INTO datetime_text (d1, d2)
VALUES
	(
		datetime('now'),
		datetime('now', 'localtime')
	);

#5

SELECT
	d1,
	typeof(d1),
	d2,
	typeof(d2)
FROM
	datetime_text;

#6

CREATE TABLE
IF NOT EXISTS datetime_real (d1 real);

#7

INSERT INTO datetime_real (d1)
VALUES
	(julianday('now'));

#8

SELECT
	d1
FROM
	datetime_real;

#9

SELECT
	date(d1),
	time(d1)
FROM
	datetime_real;

#10

CREATE TABLE
IF NOT EXISTS datetime_int (d1 int);

#11

INSERT INTO datetime_int (d1)
VALUES
	(strftime('%s','now'));

#12

SELECT
	d1
FROM
	datetime_int;

#13

SELECT
	datetime(d1,'unixepoch')
FROM
	datetime_int;