Closed
Bug 602165
Opened 15 years ago
Closed 15 years ago
Use date math functions (sql_date_math) instead of sql_interval
Categories
(Bugzilla :: Database, enhancement)
Tracking
()
RESOLVED
FIXED
Bugzilla 4.2
People
(Reporter: mkanat, Assigned: mkanat)
References
(Blocks 1 open bug)
Details
Attachments
(1 file)
|
13.58 KB,
patch
|
glob
:
review+
|
Details | Diff | Splinter Review |
Both MS-SQL and SQLite do not support the normal "INTERVAL" system for adding dates. So, instead of having a sql_interval function, we should have a sql_date_math function that does addition and subtraction of intervals from dates.
|
Assignee | |
Comment 1•15 years ago
|
||
This was actually a lot simpler than I expected.
Comment on attachment 481177 [details] [diff] [review]
v1
r=glob
Attachment #481177 -
Flags: review?(glob) → review+
|
|
Assignee | |
Updated•15 years ago
|
Flags: approval+
|
|
Assignee | |
Comment 4•15 years ago
|
||
Committing to: bzr+ssh://bzr.mozilla.org/bugzilla/trunk/
modified duplicates.cgi
modified sanitycheck.cgi
modified userprefs.cgi
modified whine.pl
modified Bugzilla/DB.pm
modified Bugzilla/Token.pm
modified Bugzilla/User.pm
modified Bugzilla/Auth/Persist/Cookie.pm
modified Bugzilla/DB/Mysql.pm
modified Bugzilla/DB/Oracle.pm
modified Bugzilla/DB/Pg.pm
modified contrib/sendunsentbugmail.pl
Committed revision 7522.
Status: ASSIGNED → RESOLVED
Closed: 15 years ago
Resolution: --- → FIXED
|
|
Assignee | |
Updated•15 years ago
|
Summary: Use date math functions (sql_date_math?) instead of sql_interval → Use date math functions (sql_date_math) instead of sql_interval
You need to log in
before you can comment on or make changes to this bug.
Description
•