Re: [Trac] strftime problem

2011-04-06 Thread Eike Jordan
/ 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

Re: [Trac] strftime problem

2011-04-05 Thread Eike Jordan
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

Re: [Trac] Width of ticket queries

2011-01-11 Thread Eike Jordan
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

Re: [Trac] Some more 0.12.1 update woes

2011-01-10 Thread Eike Jordan
, 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

[Trac] Re: Make custom ticket field comparable with time

2009-02-16 Thread Eike Jordan
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

[Trac] Make custom ticket field comparable with time

2009-02-13 Thread Eike Jordan
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