Based on the problems encountered by mssql and mysql

  • 2020-05-17 06:48:56
  • OfStack

Today, I encountered a problem. When importing sql server data into mysql database through php's mssql function, sql server datetime data cannot be directly exported through select. It must be converted into varchar data first, and then imported into mysql library.

convert(varchar,  'the field name ', 120)    ( sql server Intermediate conversion method) 



Related articles: