I'm having problems getting a valid value for seconds() from a time field
under Sqlite. I can extract a time:

>>> for row in db(db.t_periods.id==40).select(db.t_periods.f_period_end):
...  print row
... 
<Row {'f_period_end': datetime.time(17, 50, 51)}>

However, if I try to get the seconds(), it returns None:

>>> for row in
>>> db(db.t_periods.id==40).select(db.t_periods.f_period_end.seconds()):
...  print row
... 
<Row {'_extra': <Row {"web2py_extract('second',t_periods.f_period_end)":
None}>}>

Both Niphlod's examples and the manual suggest that this should give the
time in seconds, but I'm getting None. Have I misunderstood?
-- 
"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