为什么在MS SQL里select convert(varchar,OrderID)+convert(varchar,orderdate,120) from dbo.Orders
这样可以得到 123452009-06-20 12:00:00 这样的字符而在MYSQL里变成了 2010 ??我想要ID+datetime,转成string(从而成唯一值)还有,怎样才能达到下面的效果? 没办法,只对MSSQL熟悉,不熟悉MYSQLdeclare sd datetime;
set sd = select max(ADatetime) from tableA;
这样可以得到 123452009-06-20 12:00:00 这样的字符而在MYSQL里变成了 2010 ??我想要ID+datetime,转成string(从而成唯一值)还有,怎样才能达到下面的效果? 没办法,只对MSSQL熟悉,不熟悉MYSQLdeclare sd datetime;
set sd = select max(ADatetime) from tableA;
mysql> create procedure p_dinoalex()
-> begin
-> declare sd datetime;
-> select max(orderdate) into sd from tx;
-> select sd;
-> end;
-> //
Query OK, 0 rows affected (0.23 sec)mysql> delimiter ;
mysql> call p_dinoalex();
+---------------------+
| sd |
+---------------------+
| 2009-06-20 00:00:00 |
+---------------------+
1 row in set (0.00 sec)Query OK, 0 rows affected (0.00 sec)mysql>