/ 100
between cast(strftime('%s','2011-01-31') as integer)
and cast(strftime('%s','2011-02-05') as integer);
12966048
12966912
Tested with SQLite 3.6.21 and 3.7.4 on Windows.
-- Christian
--
Eike Jordan jor...@fiz-chemie.de
| FIZ CHEMIE BERLIN
| Franklin Str. 11
to in the above, but in general time values are now
stored as *microseconds* since epoch, no
longer as seconds. This might explain your problem.
-- Christian
--
Eike Jordan jor...@fiz-chemie.de
| FIZ CHEMIE BERLIN
| Franklin Str. 11 --,__o
| 10587 Berlin
see this?
--
Eike Jordan jor...@fiz-chemie.de
| FIZ CHEMIE BERLIN
| Franklin Str. 11 --,__o
| 10587 Berlin -- _-\_,
| -- (+)/'(+)
| Tel. : 0049-30-39977 214
--
You received this message because you
, 0.10.4, config)
config_merged = merge(config, default)
write(file, 0.12.1, config_merged)
# EOF
--
Eike Jordan jor...@fiz-chemie.de
| FIZ CHEMIE BERLIN
| Franklin Str. 11 --,__o
| 10587 Berlin
Remy Blank wrote:
Eike Jordan wrote:
Dear list,
we recently installed the TracDateField plugin (trac 0.10.4) with a
due_to_close
field (DD-MM- format). What i try to figure out now is, how to make those
due_to_close values comparable with the actual datetime e.g. in order to
create
BY time, c.value
which results in something like
Ticket Summary DueDays
#468brew new tea 29-01-2009 None
...
Thanks in advance.
--
Eike Jordan jor...@fiz-chemie.de
| FIZ CHEMIE BERLIN
| Franklin Str. 11 --,__o
| 10587 Berlin