SELECT GETDATE() AS CurrentDateTime我調(diào)用getdate（）這個函數(shù)時，為什么總是報錯：#1305 - FUNCTION yyc.GETDATE does not exist數(shù)據(jù)庫名叫yyc
2 回答
侃侃無極
TA貢獻(xiàn)2051條經(jīng)驗 獲得超10個贊
GETDATE () 是 SQL Server 的函數(shù)。
MySQL 里面,用 NOW () 函數(shù)
mysql> use test
Database changed
mysql> SELECT GETDATE() AS CurrentDateTime
-> ;
ERROR 1305 (42000): FUNCTION test.GETDATE does not exist
mysql> select now() as CurrentDateTime;
+---------------------+
| CurrentDateTime |
+---------------------+
| 2011-09-23 15:18:02 |
+---------------------+
1 row in set (0.00 sec)
- 2 回答
- 0 關(guān)注
- 837 瀏覽
添加回答
舉報
0/150
提交
取消