Lines Matching full:01
26 datetest 1.1 julianday('2000-01-01') 2451544.5
27 datetest 1.2 julianday('1970-01-01') 2440587.5
31 datetest 1.6 {julianday('2000-01-01 12:00:00')} 2451545
32 datetest 1.7 {julianday('2000-01-01 12:00')} 2451545
36 datetest 1.11 julianday('1999-13-01') NULL
39 datetest 1.14 julianday('+2000-01-01') NULL
40 datetest 1.15 julianday('200-01-01') NULL
41 datetest 1.16 julianday('2000-1-01') NULL
42 datetest 1.17 julianday('2000-01-1') NULL
43 datetest 1.18 {julianday('2000-01-01 12:00:00')} 2451545
44 datetest 1.19 {julianday('2000-01-01 12:00:00.1')} 2451545.00000116
45 datetest 1.20 {julianday('2000-01-01 12:00:00.01')} 2451545.00000012
46 datetest 1.21 {julianday('2000-01-01 12:00:00.001')} 2451545.00000001
47 datetest 1.22 {julianday('2000-01-01 12:00:00.')} NULL
49 datetest 1.24 {julianday('2001-01-01 12:00:00 bogus')} NULL
50 datetest 1.25 {julianday('2001-01-01 bogus')} NULL
52 datetest 2.1 datetime(0,'unixepoch') {1970-01-01 00:00:00}
53 datetest 2.2 datetime(946684800,'unixepoch') {2000-01-01 00:00:00}
65 {2003-10-01 00:00:00}
67 {2003-01-01 00:00:00}
100 datetest 3.11.2 {strftime('%W','2004-01-01')} 00
101 datetest 3.11.3 {strftime('%W','2004-01-02')} 00
102 datetest 3.11.4 {strftime('%W','2004-01-03')} 00
103 datetest 3.11.5 {strftime('%W','2004-01-04')} 00
104 datetest 3.11.6 {strftime('%W','2004-01-05')} 01
105 datetest 3.11.7 {strftime('%W','2004-01-06')} 01
106 datetest 3.11.8 {strftime('%W','2004-01-07')} 01
107 datetest 3.11.9 {strftime('%W','2004-01-08')} 01
108 datetest 3.11.10 {strftime('%W','2004-01-09')} 01
112 datetest 3.11.14 {strftime('%W','2007-01-01')} 01
135 datetest 5.4 {datetime('1994-04-16 14:00:00 +11:55')} {1994-04-17 01:55:00}
143 {2000-10-29 01:59:00}
145 {2000-10-29 01:00:00}
147 {2000-04-02 01:59:00}
150 datetest 6.5 {datetime('2000-10-29 01:59:00','utc')} {2000-10-29 05:59:00}
152 datetest 6.7 {datetime('2000-04-02 01:59:00','utc')} {2000-04-02 06:59:00}
155 datetest 6.10 {datetime('2000-01-01 12:00:00','localtime')} \
156 {2000-01-01 07:00:00}
157 datetest 6.11 {datetime('1969-01-01 12:00:00','localtime')} \
158 {1969-01-01 07:00:00}
159 datetest 6.12 {datetime('2039-01-01 12:00:00','localtime')} \
160 {2039-01-01 07:00:00}
161 datetest 6.13 {datetime('2000-07-01 12:00:00','localtime')} \
162 {2000-07-01 08:00:00}
163 datetest 6.14 {datetime('1969-07-01 12:00:00','localtime')} \
164 {1969-07-01 07:00:00}
165 datetest 6.15 {datetime('2039-07-01 12:00:00','localtime')} \
166 {2039-07-01 07:00:00}
168 [db eval {SELECT strftime('%s','2000-07-01 12:34:56')}]
169 datetest 6.16 {datetime('now','localtime')} {2000-07-01 08:34:56}
201 datetest 8.5 {datetime('now','start of month')} {2003-10-01 00:00:00}
202 datetest 8.6 {datetime('now','start of year')} {2003-01-01 00:00:00}
228 # datetime() with just an HH:MM:SS correctly inserts the date 2000-01-01.
230 datetest 10.1 {datetime('01:02:03')} {2000-01-01 01:02:03}
231 datetest 10.2 {date('01:02:03')} {2000-01-01}
232 datetest 10.3 {strftime('%Y-%m-%d %H:%M','01:02:03')} {2000-01-01 01:02}
236 datetest 11.1 {datetime('2004-02-28 20:00:00', '-01:20:30')} \
246 datetest 11.6 {datetime('2004-02-28 20:00:00', '-12:01')} \
249 {2004-02-28 08:01:00}
252 datetest 11.9 {datetime('2004-02-28 20:00:00', '12:01')} \
253 {2004-02-29 08:01:00}