Modify ↓
#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 |
Description
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 14 years ago by
Resolution: | → fixed |
---|---|
Status: | new → closed |
comment:2 Changed 12 years ago by
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.
Note: See
TracTickets for help on using
tickets.
(In [9293]) Make timestamps cross-db platform
Fixes #7823