Home
last modified time | relevance | path

Searched refs:date (Results 1 – 25 of 33) sorted by relevance

12

/sqlite-3.40.0/test/
H A Ddate.test33 do_test date-$tnum [subst {
293 do_catchsql_test date-6.20 {
316 datetest 7.7 {date(null)} NULL
317 datetest 7.8 {date('now',null)} NULL
396 do_test date-13.1 {
445 do_test date-14.1 {
466 do_test date-14.2.$i {
468 expr {$date eq "2008-06-12 00:00:00" || $date eq "2008-06-11 23:59:59"}
481 do_test date-15.1 {
488 do_test date-15.2 {
[all …]
H A Dtkt2192.test32 date real,
45 select strftime('%Y-%m', date) as date, (-1 * sum(value)) as value
47 group by strftime('%Y-%m', date);
51 select strftime('%Y-%m', date) as date, (-1 * sum(value)) as value
54 group by strftime('%Y-%m', date);
57 select strftime('%Y-%m', date) as date, (-1 * sum(value)) as value
62 group by strftime('%Y-%m', date);
65 select strftime('%Y-%m', date) as date, (-1 * sum(value)) as value
67 group by strftime('%Y-%m', date);
80 where date like '%-01';
[all …]
H A Ddate2.test12 # focus of this file is testing date and time functions used in
19 # Skip this whole file if date and time functions are omitted
33 } {1 {non-deterministic use of date() in a CHECK constraint}}
44 CREATE TABLE t1(x, y, z AS (date()));
46 } {1 {non-deterministic use of date() in a generated column}}
51 CREATE INDEX t2y ON t2(date(y));
55 } {1 {non-deterministic use of date() in an index}}
93 WHERE date(b) BETWEEN '2017-06-01' AND '2017-08-31';
94 } {1 {non-deterministic use of date() in an index}}
98 WHERE date(b) BETWEEN '2017-06-01' AND '2017-08-31';
[all …]
H A Ddate3.test12 # focus of this file is testing date and time functions.
18 # Skip this whole file if date and time functions are omitted
74 foreach {tn jd date} {
89 datetest $tn "datetime($jd,'auto')" $date
95 datetest 2.30 {date('2022-01-29','auto')==date('2022-01-29')} {1}
98 # with date/time values even in cases where it is not known if the
H A Dtkt-313723c356.test44 # cache is out of date. When the bug existed and the right xShmLock() fails
48 # cached (out-of-date) version of table t1 with the on disk (up-to-date)
H A Dfts3query.test112 CREATE TABLE t1(number INTEGER PRIMARY KEY, date);
113 CREATE INDEX i1 ON t1(date);
119 SELECT t1.number FROM t1, ft WHERE t1.number=ft.rowid ORDER BY t1.date
126 SELECT t1.number FROM ft, t1 WHERE t1.number=ft.rowid ORDER BY t1.date
133 SELECT t1.number FROM t1, bt WHERE t1.number=bt.rowid ORDER BY t1.date
140 SELECT t1.number FROM bt, t1 WHERE t1.number=bt.rowid ORDER BY t1.date
H A Dpg_common.tcl130 proc start_test {name date} { argument
135 # $date
H A Dbackup4.test19 # to become confused and continue using out-of-date cache data.
33 # date schema in test case 1.2.
H A Dtable.test639 unset -nocomplain date time seconds
640 foreach {date time seconds} {
653 } [list $time $date [list $date $time]]
H A Dwal2.test180 # wal-index header is replaced with a valid, but out-of-date, header.
184 # header is out-of-date, the reader reads the out-of-date snapshot.
187 # to run recovery. This time, it sees an up-to-date snapshot of the
H A Dtpch01.test184 and o_orderdate >= '1994-08-01' and o_orderdate < date('1994-08-01', '+3 month')
H A Dfuzz-oss1.test270 …OUNT) FROM v_operation s WHERE s.rd_account_id=v_account.id AND s.d_date<=date('now') AND s.t_temp…
545 "ncal:date" INTEGER, "ncal:date:graph" INTEGER, "ncal:date:localDate"
546 INTEGER, "ncal:date:localTime" INTEGER, "ncal:dateTime" INTEGER,
1379 CREATE TABLE "rdfs:Resource_dc:date" (ID INTEGER NOT NULL, "dc:date"
1380 INTEGER NOT NULL, "dc:date:graph" INTEGER, "dc:date:localDate" INTEGER
1381 NOT NULL, "dc:date:localTime" INTEGER NOT NULL);
1826 "rdfs:Resource_dc:date" (ID, "dc:date");
H A Dwalvfs.test369 # a version 2 VFS makes a checkpoint with an out-of-date cache.
H A Dtemptable2.test329 # open. For a temp file, the on-disk version may not be up to date.
H A Dwal.test832 # that had an out-of-date pager-cache, the next time the connection was
833 # used it did not realize the cache was out-of-date and proceeded to
1278 # as [db2] had an out-of-date copy of the wal-index header when it was
H A Dlock.test49 # Update: The schema is now brought up to date by test lock-1.5.
H A Dmalloc.test786 # then it won't realize that the cached data is out of date. Since
787 # the cached data won't match the up to date index data read from
H A Dpermutations.test354 date.test dbstatus2.test dbstatus.test default.test delete2.test
660 conflict.test date.test delete.test expr.test fkey1.test func.test
/sqlite-3.40.0/ext/fts5/tool/
H A Dmkfts5c.tcl62 set date [lindex $L [expr [lsearch -exact $L D]+1]]
63 set idx [expr {[string last . $date]-1}]
64 set date [string range $date 0 $idx]
65 set date [string map {T { }} $date]
67 return "fts5: $date $uuid"
/sqlite-3.40.0/
H A DMakefile.in175 date.lo dbpage.lo dbstat.lo delete.lo \
224 $(TOP)/src/date.c \
488 $(TOP)/src/date.c \
859 date.lo: $(TOP)/src/date.c $(HDR)
860 $(LTCOMPILE) $(TEMP_STORE) -c $(TOP)/src/date.c
H A DMakefile.msc1243 date.lo dbpage.lo dbstat.lo delete.lo \
1306 $(TOP)\src\date.c \
1974 date.lo: $(TOP)\src\date.c $(HDR)
1975 $(LTCOMPILE) $(CORE_COMPILE_OPTS) -c $(TOP)\src\date.c
H A Dmain.mk60 date.o dbpage.o dbstat.o delete.o expr.o \
101 $(TOP)/src/date.c \
407 $(TOP)/src/date.c \
/sqlite-3.40.0/ext/fts5/test/
H A Dfts5content.test110 -- Triggers to keep the FTS index up to date.
/sqlite-3.40.0/ext/fts3/
H A DREADME.content141 up to date with respect to the set of documents stored in the content table.
/sqlite-3.40.0/src/
H A Ddate.c1343 PURE_DATE(date, -1, 0, 0, dateFunc ), in sqlite3RegisterDateTimeFunctions()

12