4 Nov
2013
4 Nov
'13
10:51 p.m.
On 04/11/13 17:25, Daniel-Constantin Mierla wrote:
Do you know if mysql accepts to set a timestamp column
with a datetime
value? I will look over the code to see if there are potential side
effects and eventually some workarounds.
Correct me if I'm wrong, but the SQL format of a datetime value is the
same as a timestamp value. Both are YYYY-MM-DD HH:MM:SS. Therefore in
the following it doesn't matter whether the '2013-11-04 12:34:56' is a
datetime or a timestamp:
mysql> create table test ( a datetime, b timestamp );
Query OK, 0 rows affected (0.01 sec)
mysql> insert into test values ( '2013-11-04 12:34:56', '2013-11-04
12:34:56' );
Query OK, 1 row affected (0.00 sec)
mysql> select * from test;
+---------------------+---------------------+
| a | b |
+---------------------+---------------------+
| 2013-11-04 12:34:56 | 2013-11-04 12:34:56 |
+---------------------+---------------------+
1 row in set (0.00 sec)
--
Alistair Cunningham
+1 888 468 3111
+44 20 799 39 799
http://integrics.com/