Home >Database >Mysql Tutorial >oracle数据导入mysql数据库日期格式问题

oracle数据导入mysql数据库日期格式问题

WBOY
WBOYOriginal
2016-06-06 09:34:361406browse

mysqloracle

从oralce数据库导出日期格式数据为 to_date('13-04-2015 16:40:12', 'dd-mm-yyyy hh24:mi:ss'),
如何把它修改为yyyy-mm-dd的形式存储到mysql数据库中,由于数据比较多,一条条修改太过麻烦,有没有什么好的方法

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