Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Fix a roundoff error in the %f converter of strftime(). Ticket #1991. (CVS 3442) |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
51b9c755ea01528e32690aabe91236ed |
| User & Date: | drh 2006-09-25 18:03:29 |
Context
|
2006-09-25
| ||
| 18:05 | CVS malfunctioned on the previous check-in. Make sure the revision to date.c was received. Ticket #1991. (CVS 3444) check-in: 433dac1f user: drh tags: trunk | |
| 18:03 | Fix a roundoff error in the %f converter of strftime(). Ticket #1991. (CVS 3442) check-in: 51b9c755 user: drh tags: trunk | |
| 18:01 | Add a pragma for activating proprietary extensions. (CVS 3441) check-in: c63d34ce user: drh tags: trunk | |
Changes
Changes to test/date.test.
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
...
272
273
274
275
276
277
278
279
280
|
# May you find forgiveness for yourself and forgive others. # May you share freely, never taking more than you give. # #*********************************************************************** # This file implements regression tests for SQLite library. The # focus of this file is testing date and time functions. # # $Id: date.test,v 1.16 2006/09/08 12:27:37 drh Exp $ set testdir [file dirname $argv0] source $testdir/tester.tcl # Skip this whole file if date and time functions are omitted # at compile-time # ................................................................................ datetest 11.9 {datetime('2004-02-28 20:00:00', '12:01')} \ {2004-02-29 08:01:00} datetest 11.10 {datetime('2004-02-28 20:00:00', '12:60')} NULL # Ticket #1964 datetest 12.1 {datetime('2005-09-01')} {2005-09-01 00:00:00} datetest 12.2 {datetime('2005-09-01','+0 hours')} {2005-09-01 00:00:00} finish_test |
|
>
>
>
>
>
>
>
>
|
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
...
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
|
# May you find forgiveness for yourself and forgive others. # May you share freely, never taking more than you give. # #*********************************************************************** # This file implements regression tests for SQLite library. The # focus of this file is testing date and time functions. # # $Id: date.test,v 1.17 2006/09/25 18:03:29 drh Exp $ set testdir [file dirname $argv0] source $testdir/tester.tcl # Skip this whole file if date and time functions are omitted # at compile-time # ................................................................................ datetest 11.9 {datetime('2004-02-28 20:00:00', '12:01')} \ {2004-02-29 08:01:00} datetest 11.10 {datetime('2004-02-28 20:00:00', '12:60')} NULL # Ticket #1964 datetest 12.1 {datetime('2005-09-01')} {2005-09-01 00:00:00} datetest 12.2 {datetime('2005-09-01','+0 hours')} {2005-09-01 00:00:00} # Ticket #1991 do_test date-13.1 { execsql { SELECT strftime('%Y-%m-%d %H:%M:%f', julianday('2006-09-24T10:50:26.047')) } } {{2006-09-24 10:50:26.047}} finish_test |