> Perhaps you could add the seconds as a virtual lazy field.

That sounds worth investigating, thanks.

> We shall come to an agreement when you explain plainly what is your real
> model... it seems that your start and end columns are "time" and not
> "datetime"... Time fields don't have a "seconds()" method, only datetime!

In my original posting, I said: "the periods table has id, date,
start_time, end_time (and other fields)". I suppose I assumed that the
presence of a 'date' field implied that the *_time fields were indeed of
type time, but I'm sorry if that wasn't clear. For clarity:

db.define_table('t_periods',
    Field('f_date', type='date',
          label=T('Date')),
    Field('f_period_start', type='time',
          label=T('Period Start')),
    Field('f_period_end', type='time',
          label=T('Period End')),
    ...

-- 
"You can have everything in life you want if you help enough other people
get what they want" - Zig Ziglar. 

Who did you help today?

Reply via email to