at start with "00:" in the criteria .. those
times will occur tomorrow.
-Original Message-
From: Paul Halliday [mailto:paul.halli...@gmail.com]
Sent: Friday, July 15, 2011 9:53 AM
To: mysql mailing list
Subject: Substring confusion.
Does anyone know why this happens:
mysql> SE
Does anyone know why this happens:
mysql> SELECT COUNT(*) AS count, SUBSTRING(timestamp,12,5) AS time
FROM event WHERE timestamp BETWEEN '2011-07-15 03:00:00' AND
'2011-07-16 02:59:59' GROUP BY time ORDER BY time limit 4;
+---+---+
| count | time |
+---+---+
| 5 | 03:00 |
|
