Lines Matching refs:datetime
54 datetest 2.1 datetime(0,'unixepoch') {1970-01-01 00:00:00}
55 datetest 2.2 datetime(946684800,'unixepoch') {2000-01-01 00:00:00}
65 datetest 2.12 {datetime('2003-10-22 12:34','weekday 0')} {2003-10-26 12:34:00}
66 datetest 2.13 {datetime('2003-10-22 12:34','start of month')} \
68 datetest 2.14 {datetime('2003-10-22 12:34','start of year')} \
70 datetest 2.15 {datetime('2003-10-22 12:34','start of day')} \
73 datetest 2.17 {datetime('2003-10-22 12:34','1 day')} {2003-10-23 12:34:00}
74 datetest 2.18 {datetime('2003-10-22 12:34','+1 day')} {2003-10-23 12:34:00}
75 datetest 2.19 {datetime('2003-10-22 12:34','+1.25 day')} {2003-10-23 18:34:00}
76 datetest 2.20 {datetime('2003-10-22 12:34','-1.0 day')} {2003-10-21 12:34:00}
77 datetest 2.21 {datetime('2003-10-22 12:34','1 month')} {2003-11-22 12:34:00}
78 datetest 2.22 {datetime('2003-10-22 12:34','11 month')} {2004-09-22 12:34:00}
79 datetest 2.23 {datetime('2003-10-22 12:34','-13 month')} {2002-09-22 12:34:00}
80 datetest 2.24 {datetime('2003-10-22 12:34','1.5 months')} {2003-12-07 12:34:00}
81 datetest 2.25 {datetime('2003-10-22 12:34','-5 years')} {1998-10-22 12:34:00}
82 datetest 2.26 {datetime('2003-10-22 12:34','+10.5 minutes')} \
84 datetest 2.27 {datetime('2003-10-22 12:34','-1.25 hours')} \
86 datetest 2.28 {datetime('2003-10-22 12:34','11.25 seconds')} \
88 datetest 2.29 {datetime('2003-10-22 12:24','+5 bogus')} NULL
134 datetest 5.1 {datetime('1994-04-16 14:00:00 -05:00')} {1994-04-16 09:00:00}
135 datetest 5.2 {datetime('1994-04-16 14:00:00 +05:15')} {1994-04-16 19:15:00}
136 datetest 5.3 {datetime('1994-04-16 05:00:00 -08:30')} {1994-04-15 20:30:00}
137 datetest 5.4 {datetime('1994-04-16 14:00:00 +11:55')} {1994-04-17 01:55:00}
144 datetest 6.1 {datetime('2000-10-29 05:59:00','localtime')}\
146 datetest 6.2 {datetime('2000-10-29 06:00:00','localtime')}\
148 datetest 6.3 {datetime('2000-04-02 06:59:00','localtime')}\
150 datetest 6.4 {datetime('2000-04-02 07:00:00','localtime')}\
152 datetest 6.5 {datetime('2000-10-29 01:59:00','utc')} {2000-10-29 05:59:00}
153 datetest 6.6 {datetime('2000-10-29 02:00:00','utc')} {2000-10-29 07:00:00}
154 datetest 6.7 {datetime('2000-04-02 01:59:00','utc')} {2000-04-02 06:59:00}
155 datetest 6.8 {datetime('2000-04-02 02:00:00','utc')} {2000-04-02 06:00:00}
157 datetest 6.10 {datetime('2000-01-01 12:00:00','localtime')} \
159 datetest 6.11 {datetime('1969-01-01 12:00:00','localtime')} \
161 datetest 6.12 {datetime('2039-01-01 12:00:00','localtime')} \
163 datetest 6.13 {datetime('2000-07-01 12:00:00','localtime')} \
165 datetest 6.14 {datetime('1969-07-01 12:00:00','localtime')} \
167 datetest 6.15 {datetime('2039-07-01 12:00:00','localtime')} \
171 datetest 6.16 {datetime('now','localtime')} {2000-07-01 08:34:56}
178 datetest 7.1 {datetime(null)} NULL
179 datetest 7.2 {datetime('now',null)} NULL
180 datetest 7.3 {datetime('now','localtime',null)} NULL
199 datetest 8.1 {datetime('now','weekday 0')} {2003-10-26 12:34:00}
200 datetest 8.2 {datetime('now','weekday 1')} {2003-10-27 12:34:00}
201 datetest 8.3 {datetime('now','weekday 2')} {2003-10-28 12:34:00}
202 datetest 8.4 {datetime('now','weekday 3')} {2003-10-22 12:34:00}
203 datetest 8.5 {datetime('now','start of month')} {2003-10-01 00:00:00}
204 datetest 8.6 {datetime('now','start of year')} {2003-01-01 00:00:00}
205 datetest 8.7 {datetime('now','start of day')} {2003-10-22 00:00:00}
206 datetest 8.8 {datetime('now','1 day')} {2003-10-23 12:34:00}
207 datetest 8.9 {datetime('now','+1 day')} {2003-10-23 12:34:00}
208 datetest 8.10 {datetime('now','+1.25 day')} {2003-10-23 18:34:00}
209 datetest 8.11 {datetime('now','-1.0 day')} {2003-10-21 12:34:00}
210 datetest 8.12 {datetime('now','1 month')} {2003-11-22 12:34:00}
211 datetest 8.13 {datetime('now','11 month')} {2004-09-22 12:34:00}
212 datetest 8.14 {datetime('now','-13 month')} {2002-09-22 12:34:00}
213 datetest 8.15 {datetime('now','1.5 months')} {2003-12-07 12:34:00}
214 datetest 8.16 {datetime('now','-5 years')} {1998-10-22 12:34:00}
215 datetest 8.17 {datetime('now','+10.5 minutes')} {2003-10-22 12:44:30}
216 datetest 8.18 {datetime('now','-1.25 hours')} {2003-10-22 11:19:00}
217 datetest 8.19 {datetime('now','11.25 seconds')} {2003-10-22 12:34:11}
223 datetest 9.2 {julianday(datetime(5))} {5}
224 datetest 9.3 {julianday(datetime(10))} {10}
225 datetest 9.4 {julianday(datetime(100))} {100}
226 datetest 9.5 {julianday(datetime(1000))} {1000}
227 datetest 9.6 {julianday(datetime(10000))} {10000}
228 datetest 9.7 {julianday(datetime(100000))} {100000}
230 # datetime() with just an HH:MM:SS correctly inserts the date 2000-01-01.
232 datetest 10.1 {datetime('01:02:03')} {2000-01-01 01:02:03}
238 datetest 11.1 {datetime('2004-02-28 20:00:00', '-01:20:30')} \
240 datetest 11.2 {datetime('2004-02-28 20:00:00', '+12:30:00')} \
242 datetest 11.3 {datetime('2004-02-28 20:00:00', '+12:30')} \
244 datetest 11.4 {datetime('2004-02-28 20:00:00', '12:30')} \
246 datetest 11.5 {datetime('2004-02-28 20:00:00', '-12:00')} \
248 datetest 11.6 {datetime('2004-02-28 20:00:00', '-12:01')} \
250 datetest 11.7 {datetime('2004-02-28 20:00:00', '-11:59')} \
252 datetest 11.8 {datetime('2004-02-28 20:00:00', '11:59')} \
254 datetest 11.9 {datetime('2004-02-28 20:00:00', '12:01')} \