you could just use import strftime set a var accordingly?
my_timestamp = time.strftime("%b %d, %Y") #shape it however you want?
write it on post/submit?templating suggestion here: http://groups.google.com/group/webpy/browse_thread/thread/687ca9a3e3ea67de?fwc=1 On Wed, Oct 13, 2010 at 11:46 AM, andrei <[email protected]> wrote: > > > I've no idea what ``SET time_zone`` does, but I'm guessing it's > > setting the time_zone for the whole database or a table? Or is it > > something on DBMS level (like for the whole MySQL installation)? Or on > > connection-level? > > > > According to http://dev.mysql.com/doc/refman/5.1/en/time-zone-support.html > it will set per-connection time zone. > > I need this to store and retrieve TIMESTAMP values in local timezone. > By default, Mysql timezone = server system timezone, which is > different from my local timezone. > > -- > You received this message because you are subscribed to the Google Groups > "web.py" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected] <webpy%[email protected]>. > For more options, visit this group at > http://groups.google.com/group/webpy?hl=en. > > -- You received this message because you are subscribed to the Google Groups "web.py" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/webpy?hl=en.
