Lines Matching refs:now

223 datetest 4.1 {date('now')} {2006-09-01}
311 datetest 7.2 {datetime('now',null)} NULL
312 datetest 7.3 {datetime('now','localtime',null)} NULL
314 datetest 7.5 {time('now',null)} NULL
315 datetest 7.6 {time('now','localtime',null)} NULL
317 datetest 7.8 {date('now',null)} NULL
318 datetest 7.9 {date('now','localtime',null)} NULL
320 datetest 7.11 {julianday('now',null)} NULL
321 datetest 7.12 {julianday('now','localtime',null)} NULL
322 datetest 7.13 {strftime(null,'now')} NULL
324 datetest 7.15 {strftime('%s','now',null)} NULL
325 datetest 7.16 {strftime('%s','now','localtime',null)} NULL
331 datetest 8.1 {datetime('now','weekday 0')} {2003-10-26 12:34:00}
332 datetest 8.2 {datetime('now','weekday 1')} {2003-10-27 12:34:00}
333 datetest 8.3 {datetime('now','weekday 2')} {2003-10-28 12:34:00}
334 datetest 8.4 {datetime('now','weekday 3')} {2003-10-22 12:34:00}
335 datetest 8.5 {datetime('now','start of month')} {2003-10-01 00:00:00}
336 datetest 8.6 {datetime('now','start of year')} {2003-01-01 00:00:00}
337 datetest 8.7 {datetime('now','start of day')} {2003-10-22 00:00:00}
338 datetest 8.8 {datetime('now','1 day')} {2003-10-23 12:34:00}
339 datetest 8.9 {datetime('now','+1 day')} {2003-10-23 12:34:00}
340 datetest 8.10 {datetime('now','+1.25 day')} {2003-10-23 18:34:00}
341 datetest 8.11 {datetime('now','-1.0 day')} {2003-10-21 12:34:00}
342 datetest 8.12 {datetime('now','1 month')} {2003-11-22 12:34:00}
343 datetest 8.13 {datetime('now','11 month')} {2004-09-22 12:34:00}
344 datetest 8.14 {datetime('now','-13 month')} {2002-09-22 12:34:00}
345 datetest 8.15 {datetime('now','1.5 months')} {2003-12-07 12:34:00}
346 datetest 8.16 {datetime('now','-5 years')} {1998-10-22 12:34:00}
347 datetest 8.17 {datetime('now','+10.5 minutes')} {2003-10-22 12:44:30}
348 datetest 8.18 {datetime('now','-1.25 hours')} {2003-10-22 11:19:00}
349 datetest 8.19 {datetime('now','11.25 seconds')} {2003-10-22 12:34:11}
350 datetest 8.90 {datetime('now','abcdefghijklmnopqrstuvwyxzABCDEFGHIJLMNOP')} NULL
473 # Verify that multiple calls to date functions with 'now' return the
476 # EVIDENCE-OF: R-34818-13664 The 'now' argument to date and time
484      SELECT c - a FROM (SELECT julianday('now') AS a,
485                                sleeper(), julianday('now') AS c);