Opened 8 years ago

Closed 8 years ago

Last modified 6 years ago

#7823 closed defect (fixed)

Use of datetime() breaks plugin with mysql backend

Reported by: anonymous Owned by: Robert Corsaro
Priority: high Component: AnnouncerPlugin
Severity: major Keywords: database API
Cc: Trac Release: 0.12


Instead of using datetime() in SQL queries, use CURRENT_TIMESTAMP, or do what other plugins do and use either trac.util.to_timestamp or trac.util.to_utimestamp.

Attachments (0)

Change History (2)

comment:1 Changed 8 years ago by Robert Corsaro

Resolution: fixed
Status: newclosed

(In [9293]) Make timestamps cross-db platform

Fixes #7823

comment:2 Changed 6 years ago by Steffen Hoffmann

Keywords: database API added

Oh no, don't use CURRENT_TIMESTAMP, because it produces non-portable time stamps! The way to go is really only the other option, hence we have to deal with #7975 now.

Modify Ticket

Change Properties
Set your email in Preferences
as closed The owner will remain Robert Corsaro.
The resolution will be deleted.

Add Comment

E-mail address and name can be saved in the Preferences.

Note: See TracTickets for help on using tickets.