> 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?