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

handsome_sai

于 2023-11-09 09:14:22 发布

阅读量182

点赞数

分类专栏：笔记文章标签：数据库

本文链接：https://blog.csdn.net/handsome_sai/article/details/134303051

版权

笔记专栏收录该内容

13 篇文章 0 订阅

订阅专栏

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

MySQL

SELECT
	NOW() 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 '字符串转日期' 
FROM
	DUAL

Oracle

SELECT
	SYSDATE 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 '字符串转日期' 
FROM
	DUAL