Lines Matching refs:date
12 # focus of this file is testing date and time functions.
14 # $Id: date.test,v 1.34 2009/04/16 12:58:03 drh Exp $
24 # Skip this whole file if date and time functions are omitted
33 do_test date-$tnum [subst {
84 datetest 2.3 {date('2003-10-22','weekday 0')} 2003-10-26
85 datetest 2.4 {date('2003-10-22','weekday 1')} 2003-10-27
86 datetest 2.4a {date('2003-10-22','weekday 1')} 2003-10-27
87 datetest 2.4b {date('2003-10-22','weekday 1x')} NULL
88 datetest 2.4c {date('2003-10-22','weekday -1')} NULL
89 datetest 2.4d {date('2003-10-22','weakday 1x')} NULL
90 datetest 2.4e {date('2003-10-22','weekday ')} NULL
91 datetest 2.5 {date('2003-10-22','weekday 2')} 2003-10-28
92 datetest 2.6 {date('2003-10-22','weekday 3')} 2003-10-22
93 datetest 2.7 {date('2003-10-22','weekday 4')} 2003-10-23
94 datetest 2.8 {date('2003-10-22','weekday 5')} 2003-10-24
95 datetest 2.9 {date('2003-10-22','weekday 6')} 2003-10-25
96 datetest 2.10 {date('2003-10-22','weekday 7')} NULL
97 datetest 2.11 {date('2003-10-22','weekday 5.5')} NULL
223 datetest 4.1 {date('now')} {2006-09-01}
253 # (3) The function fails for the specific date/time value
258 do_execsql_test date-$tn "SELECT datetime('$utc','localtime')" [list $local]
261 do_execsql_test date-$tn "SELECT datetime('$local','utc')" [list $utc]
293 do_catchsql_test date-6.20 {
316 datetest 7.7 {date(null)} NULL
317 datetest 7.8 {date('now',null)} NULL
318 datetest 7.9 {date('now','localtime',null)} NULL
327 # Test modifiers when the date begins as a julian day number - to
363 # datetime() with just an HH:MM:SS correctly inserts the date 2000-01-01.
366 datetest 10.2 {date('01:02:03')} {2000-01-01}
396 do_test date-13.1 {
432 datetest 13.30 {date('2000-01-01','+1.5 years')} {2001-07-02}
433 datetest 13.31 {date('2001-01-01','+1.5 years')} {2002-07-02}
434 datetest 13.32 {date('2002-01-01','+1.5 years')} {2003-07-02}
435 datetest 13.33 {date('2002-01-01','-1.5 years')} {2000-07-02}
436 datetest 13.34 {date('2001-01-01','-1.5 years')} {1999-07-02}
445 do_test date-14.1 {
466 do_test date-14.2.$i {
467 set date [db one {SELECT datetime(x) FROM t1}]
468 expr {$date eq "2008-06-12 00:00:00" || $date eq "2008-06-11 23:59:59"}
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
481 do_test date-15.1 {
488 do_test date-15.2 {
495 # Tests of extreme values in date/time functions. Run with UBSan or the
498 datetest 16.1 {date(147483649)} NULL