2012/07/24 13:07 -0700, Hassan Schroeder
On Tue, Jul 24, 2012 at 10:36 AM, Roberta Jaskólski h...@tbbs.net wrote:
version(): 5.5.8-log
@@sql_mode:
2012/07/23 11:54 -0700, Rick James
mysql SELECT YEAR(NOW());
+-+
| YEAR(NOW()) |
+-+
|2012 |
+-+
mysql SELECT CONCAT('2012', '-01-01');
+--+
| CONCAT('2012', '-01-01') |
+--+
| 2012-01-01 |
2012/07/24 08:46 -0700, Hassan Schroeder
On Mon, Jul 23, 2012 at 5:58 AM, h...@tbbs.net wrote:
I thought I would try YEAR to record it--but, in spite of
http://dev.mysql.com/doc/refman/5.5/en/year.html , simply assigning NOW() to
such a type does not work.
Not sure I understand the
mysql SELECT YEAR(NOW());
+-+
| YEAR(NOW()) |
+-+
|2012 |
+-+
mysql SELECT CONCAT('2012', '-01-01');
+--+
| CONCAT('2012', '-01-01') |
+--+
| 2012-01-01 |
+--+
To