On Sat, Mar 11, 2006 at 02:00:47PM -0500, Sells, Fred wrote:
> I'm storing datetime values as GMT. I would like to use the built-in MySQL
> function "convert_tz" to convert to local time. Is there a way in SQLobject
> to use the built-in mysql functions in a select?
from sqlobject.sqlbuilder import func
MyTable.select(func.convert_tz(MyTable.q.datetime_field) == value)
Oleg.
--
Oleg Broytmann http://phd.pp.ru/ [EMAIL PROTECTED]
Programmers don't die, they just GOSUB without RETURN.
-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
