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
A director s term ends in a given year, but at no given time of year; depends
on the yearly meeting.
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. There is also no implicit
|
+---+
-Original Message-
From: h...@tbbs.net [mailto:h...@tbbs.net]
Sent: Monday, July 23, 2012 5:59 AM
To: mysql@lists.mysql.com
Subject: YEAR and time types
A director s term ends in a given year, but at no given time of year;
depends on the yearly meeting.
I thought