Reputation
4,415
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
1 14 34
Newest
 Suffrage
Impact
~168k people reached

1h
reviewed Close Retrieve data from corrupted hard drive
1h
reviewed Edit How to COUNT number of rows with LIMIT?
1h
revised How to COUNT number of rows with LIMIT?
formatting
4h
reviewed Edit Increase date by 1
4h
revised Increase date by 1
edited body
6h
revised Get Column Value from Subquery in Stored Procedure
formatting, spelling, grammar, tagging
7h
comment Increase date by 1
I see, but then you'll have the same issue with the DATE_ADD in your query. Anyway, that's resolved easily using DATE(): DATE_ADD(DATE(s.proddate),INTERVAL '22:30:00' HOUR_SECOND).
8h
comment Increase date by 1
I'd probably replace the CONCAT bit with DATE_ADD(s.proddate,INTERVAL '22:30:00' HOUR_SECOND) as both a cleaner way and a more consistent one with the other expression.
9h
reviewed Reviewed How to get month name from week number and year
9h
revised How to get month name from week number and year
grammar
9h
reviewed Reject Db Design of a Room Booking System
9h
reviewed Close data warehouse automation tool: benefit or bane?
9h
revised data warehouse automation tool: benefit or bane?
foramtting
9h
reviewed Close MySQL best performance settings
9h
revised MySQL best performance settings
added 3 characters in body
9h
revised MySQL best performance settings
deleted 23 characters in body; edited title
9h
reviewed Close Microsoft SQL Server Vs Oracle
9h
reviewed Leave Open Install Express/Standard side-by-side
9h
comment Install Express/Standard side-by-side
Work with Multiple Versions and Instances of SQL Server. That manual page doesn't make distinctions between different editions of the same version, but from my personal experience I can tell you I've had no issues running an Express and a Standard alongside each other (although they were 2008 R2, not 2014).
23h
reviewed Reviewed Count is slow Oracle