are you aware that web2py handles timezones automatically if set to do so ?
If you want to leverage mysql own function, you have to write raw queries for that. On Friday, June 28, 2013 11:35:03 AM UTC+2, Stelios Koroneos wrote: > > Greetings. > > I am saving all time related references in UTC timezone and want to > convert them to the user's timezone when the request to display them comes. > Mysql offers the convert_tz which can handle this pretty much > 'automagically' during the query. > Is there a way to use convert_tz from a 'standard' DAL query or do in need > to create raw sql queries to handle this ? > > > Stelios > > -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
