MySQL、Oracle中字符串和日期之间的相互转换

字符串和日期之间的相互转换"/>

MySQL、Oracle中字符串和日期之间的相互转换

MySQL、Oracle中字符串和日期之间的相互转换

MySQL

SELECTNOW() AS '获取当前时间',DATE_FORMAT( NOW(), '%Y-%m-%d %H:%i:%s' ) AS '日期转字符串',STR_TO_DATE( '2023-11-09 08:30:00', '%Y-%m-%d %H:%i:%s' ) AS '字符串转日期' 
FROMDUAL 

Oracle

SELECTSYSDATE AS '获取当前时间',TO_CHAR ( SYSDATE, 'yyyy-mm-dd hh24:mi:ss' ) AS '日期转字符串',TO_DATE ( '2023-11-09 08:30:00', 'yyyy-mm-dd hh24:mi:ss' ) AS '字符串转日期' 
FROMDUAL