<\/span><\/h3>\n\n\n\n\u8fd9\u4e2a\u4e00\u822c\u6ca1\u6709\u635f\u5931\u3002<\/p>\n\n\n\n
\u539f\u59cb\u6570\u636e<\/p>\n\n\n\n
gbase> desc t2;\r\n+-------+--------------+------+-----+---------+-------+\r\n| Field | Type | Null | Key | Default | Extra |\r\n+-------+--------------+------+-----+---------+-------+\r\n| id | int(11) | YES | | NULL | |\r\n| name | varchar(100) | YES | | NULL | |\r\n| pid | int(11) | YES | | NULL | |\r\n+-------+--------------+------+-----+---------+-------+\r\n3 rows in set (Elapsed: 00:00:00.00)\r\n\r\ngbase> select * from t2;\r\n+------+-----------+------+\r\n| id | name | pid |\r\n+------+-----------+------+\r\n| 1 | First | 0 |\r\n| 2 | Fist_1 | 1 |\r\n| 3 | First_2 | 1 |\r\n| 4 | First_1_1 | 2 |\r\n+------+-----------+------+\r\n4 rows in set (Elapsed: 00:00:00.00)\r\n<\/code><\/pre>\n\n\n\n\u5f3a\u5236\u8f6c\u6362<\/p>\n\n\n\n
gbase> create table t2_1 as select cast(id as char) id, name,pid from t2;\r\nQuery OK, 4 rows affected (Elapsed: 00:00:00.15)\r\n\r\ngbase> desc t2_1;\r\n+-------+--------------+------+-----+---------+-------+\r\n| Field | Type | Null | Key | Default | Extra |\r\n+-------+--------------+------+-----+---------+-------+\r\n| id | varchar(11) | YES | | NULL | |\r\n| name | varchar(100) | YES | | NULL | |\r\n| pid | int(11) | YES | | NULL | |\r\n+-------+--------------+------+-----+---------+-------+\r\n3 rows in set (Elapsed: 00:00:00.00)\r\n\r\ngbase> select * fro mt2_1;\r\nERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your GBase server version for the right syntax to use near 'fro mt2_1' at line 1\r\ngbase> select * from t2_1;\r\n+------+-----------+------+\r\n| id | name | pid |\r\n+------+-----------+------+\r\n| 1 | First | 0 |\r\n| 2 | Fist_1 | 1 |\r\n| 3 | First_2 | 1 |\r\n| 4 | First_1_1 | 2 |\r\n+------+-----------+------+\r\n4 rows in set (Elapsed: 00:00:00.01)\r\n<\/code><\/pre>\n\n\n\n<\/span>\u8f6c\u5316\u4e3a\u6570\u5b57<\/span><\/h3>\n\n\n\n\u8fd9\u4e2a\u8981\u770b\u5b57\u7b26\u80fd\u5426\u8f6c\u6362\uff0c\u4ee5\u53ca\u76ee\u6807\u6570\u5b57\u7c7b\u578b\u7684\u7cbe\u5ea6\u3002<\/p>\n\n\n\n
<\/span>\u5b8c\u5168\u65e0\u6cd5\u8f6c\u6362<\/span><\/h4>\n\n\n\n\u7ed3\u679c\u5168\u53d8\u6210\u4e860\u3002<\/p>\n\n\n\n
gbase> select name,cast(name as int) from t2;\r\n+-----------+-------------------+\r\n| name | cast(name as int) |\r\n+-----------+-------------------+\r\n| First | 0 |\r\n| Fist_1 | 0 |\r\n| First_2 | 0 |\r\n| First_1_1 | 0 |\r\n+-----------+-------------------+\r\n4 rows in set, 4 warnings (Elapsed: 00:00:00.00)\r\n\r\ngbase> show warnings;\r\n+-------+------+---------------------------------------------------------------------+\r\n| Level | Code | Message |\r\n+-------+------+---------------------------------------------------------------------+\r\n| Note | 1292 | gbase_rh7_001:5050 - Truncated incorrect INTEGER value: 'First' |\r\n| Note | 1292 | gbase_rh7_001:5050 - Truncated incorrect INTEGER value: 'Fist_1' |\r\n| Note | 1292 | gbase_rh7_001:5050 - Truncated incorrect INTEGER value: 'First_2' |\r\n| Note | 1292 | gbase_rh7_001:5050 - Truncated incorrect INTEGER value: 'First_1_1' |\r\n+-------+------+---------------------------------------------------------------------+\r\n4 rows in set (Elapsed: 00:00:00.00)\r\n\r\n<\/code><\/pre>\n\n\n\n<\/span>\u90e8\u5206\u8f6c\u6362<\/span><\/h4>\n\n\n\n\u5b57\u7b26\u7684\u524d\u9762\u90e8\u5206\u80fd\u8f6c\u6362\u4e3a\u6570\u5b57\uff0c\u5219\u53ea\u51c6\u6362\u90e8\u5206\u3002<\/p>\n\n\n\n
gbase> select cast(now() as int) from t2;\r\n+--------------------+\r\n| cast(now() as int) |\r\n+--------------------+\r\n| 2020 |\r\n| 2020 |\r\n| 2020 |\r\n| 2020 |\r\n+--------------------+\r\n4 rows in set, 1 warning (Elapsed: 00:00:00.00)\r\n\r\ngbase> select cast('1919-01-02' as int) from t2;\r\n+---------------------------+\r\n| cast('1919-01-02' as int) |\r\n+---------------------------+\r\n| 1919 |\r\n| 1919 |\r\n| 1919 |\r\n| 1919 |\r\n+---------------------------+\r\n4 rows in set, 1 warning (Elapsed: 00:00:00.00)\r\n\r\ngbase> select cast('03-02' as int) from t2;\r\n+----------------------+\r\n| cast('03-02' as int) |\r\n+----------------------+\r\n| 3 |\r\n| 3 |\r\n| 3 |\r\n| 3 |\r\n+----------------------+\r\n4 rows in set, 1 warning (Elapsed: 00:00:00.00)\r\n\r\n<\/code><\/pre>\n\n\n\n<\/span>\u8f6c\u6362\u4e3a\u65e5\u671f<\/span><\/h3>\n\n\n\n<\/span>\u6b63\u5e38\u8f6c\u6362<\/span><\/h4>\n\n\n\ngbase> select cast('2020-01-02' as date);\r\n+----------------------------+\r\n| cast('2020-01-02' as date) |\r\n+----------------------------+\r\n| 2020-01-02 |\r\n+----------------------------+\r\n1 row in set (Elapsed: 00:00:00.00)\r\n<\/code><\/pre>\n\n\n\n<\/span>\u90e8\u5206\u8f6c\u6362<\/span><\/h4>\n\n\n\n\u6700\u524d\u9762\u7684\u90e8\u5206\u6ee1\u8db3\u683c\u5f0f\u8981\u6c42\uff0c\u5219\u8f6c\u6362\u3002<\/p>\n\n\n\n
gbase> select cast('2020-01-02 ABCDE' as date);\r\n+----------------------------------+\r\n| cast('2020-01-02 ABCDE' as date) |\r\n+----------------------------------+\r\n| 2020-01-02 |\r\n+----------------------------------+\r\n1 row in set, 1 warning (Elapsed: 00:00:00.00)\r\n\r\ngbase> show warnings;\r\n+---------+------+----------------------------------------------------+\r\n| Level | Code | Message |\r\n+---------+------+----------------------------------------------------+\r\n| Warning | 1292 | Truncated incorrect date value: '2020-01-02 ABCDE' |\r\n+---------+------+----------------------------------------------------+\r\n1 row in set (Elapsed: 00:00:00.00)\r\n<\/code><\/pre>\n\n\n\n<\/span>\u4e0d\u80fd\u51c6\u6362<\/span><\/h4>\n\n\n\n\u8fd4\u56deNULL<\/p>\n\n\n\n
gbase> select cast('2020' as date);\r\n+----------------------+\r\n| cast('2020' as date) |\r\n+----------------------+\r\n| NULL |\r\n+----------------------+\r\n1 row in set, 1 warning (Elapsed: 00:00:00.00)\r\n\r\ngbase> select cast('2020-01' as date);\r\n+-------------------------+\r\n| cast('2020-01' as date) |\r\n+-------------------------+\r\n| NULL |\r\n+-------------------------+\r\n1 row in set, 1 warning (Elapsed: 00:00:00.00)\r\ngbase> select cast('20200102 ABCDE' as date);\r\n+--------------------------------+\r\n| cast('20200102 ABCDE' as date) |\r\n+--------------------------------+\r\n| NULL |\r\n+--------------------------------+\r\n1 row in set, 1 warning (Elapsed: 00:00:00.00)\r\n\r\ngbase> show warnings;\r\n+---------+------+--------------------------------------------+\r\n| Level | Code | Message |\r\n+---------+------+--------------------------------------------+\r\n| Warning | 1292 | Incorrect datetime value: '20200102 ABCDE' |\r\n+---------+------+--------------------------------------------+\r\n1 row in set (Elapsed: 00:00:00.00)\r\n<\/code><\/pre>","protected":false},"excerpt":{"rendered":"\u5357\u5927\u901a\u7528GBase 8a\u6570\u636e\u5e93\u96c6\u7fa4\u652f\u6301\u591a\u79cd\u6570\u636e\u7c7b\u578b\uff0c\u4ece\u5927\u7c7b\u770b\u5305\u62ecCHAR\u3001DATE\u3001DATETIME\u3001DECIMAL\u3001TIME\u3001NUMERIC\u3001INT\u3002\u5bf9\u5e94\u5b57\u7b26\uff0c\u65e5\u671f\uff0c\u65e5\u671f\u65f6\u95f4\uff0c\u5927\u7cbe\u5ea6\u6570\u5b57\uff0c\u65f6\u95f4\uff0c\u6d6e\u70b9\u6570\uff0c\u6574\u6570\u3002\u672c\u6587\u4ecb\u7ecd\u901a\u8fc7cast\u6216convert\u51fd\u6570\u5c06\u6570\u636e\u5728\u4e0d\u540c\u7684\u7c7b\u578b\u95f4\u5f3a\u5236\u8f6c\u6362\u7684\u65b9\u6cd5\u3002<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[36],"class_list":["post-2653","post","type-post","status-publish","format-standard","hentry","category-gbase8a","tag-36"],"_links":{"self":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/2653","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/comments?post=2653"}],"version-history":[{"count":1,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/2653\/revisions"}],"predecessor-version":[{"id":2654,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/2653\/revisions\/2654"}],"wp:attachment":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/media?parent=2653"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/categories?post=2653"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/tags?post=2653"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}