 <p>"Is this possible in SQL?"</p> <p>Yes</p> <p>I would suggest having 2 rows with each value (one for the Date, one for the Integer).</p> <p>What you would need is the following: a trigger for insertions that adds the NOW() value to a field. Then concat the Integer to that Date.</p> <p>And another trigger to reset the Integer value at the change of day (the hour you chose)</p>