SQL语句中将字符串转换为时间格式

最新推荐文章于 2024-08-27 16:03:46 发布

webmelon

最新推荐文章于 2024-08-27 16:03:46 发布

阅读量1.2w

点赞数

分类专栏：服务器文章标签： sql list date access oracle

本文链接：https://blog.csdn.net/webmelon/article/details/658703

版权

服务器专栏收录该内容

18 篇文章 0 订阅

订阅专栏

字符串 datetext="2005-10-10"

SQL Server/MYSQL中：
cast('2005-10-10' as datetime)
如：select * from cds where zno = "+list+" and ChnNo = "+list2+" and RecDate= cast(' "+datetext+" ' as datetime) order by rdt

ORACLE中：
to_date('2005-10-10')
如：select * from cds where zno = "+list+" and ChnNo = "+list2+" and RecDate= to_date(' "+datetext+" ','yyyy-mm-dd') order by rdt

ACCESS中：
select * from cds where zno = "+list+" and ChnNo = "+list2+" and RecDate= #"+datetext+"# order by rdt