Am 05.10.2009 23:52, schrieb tex:
I made following custom query that enables me to track task&story owner changes. But problem is, that I don't know how to extract date from time field. I saw some examples with strftime for trac, but this function does not exist in mysql. How can I change query so that change date is included?
The changetime is stored as seconds since 1.1.1970 in the UTC 'timezone' (unix timestamp).
I'm pretty sure that even MySQL can do something with that: http://www.google.com/search?q=mysql+timestamp+to+date fs
smime.p7s
Description: S/MIME Cryptographic Signature
