sql语句的字段转成Date

ms_sql:
convert(datetime,'2010-11-13')
cast('2017-01-01' as datetime)


Oracle:
to_date('2017-01-01')


mysql:
date_format('2017-01-01','%Y-%c-%d')
posted @ 2017-09-27 15:37  还行吗年轻人  阅读(614)  评论(0编辑  收藏  举报