Home >Database >Mysql Tutorial >基于mssql导mysql遇到的问题_MySQL
基于mssql导mysql遇到的问题_MySQL
- WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
- 2016-06-01 13:24:361000browse
bitsCN.com
今天遇到一个问题，在通过php的mssql函数读取sql server数据导入mysql数据库时，sql server 的datetime类型数据不能直接通过select出来，必须要先转换为varchar类型数据,然后导入到mysql库中.
convert(varchar, ‘字段名', 120) （sql server中转换方法）
bitsCN.com
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：SQL字符串以及数字常用操作汇总_MySQLNext article：深入MYSQL字符数字转换的详解_MySQL