Submit My Question - Recent Questions - Recent Answer

Msdn China Tech >> MS-SQL Server >> 疑难问题

SQL语句中如何将字符串转化为日期类型?

比如，利用SQL语句如何将'2006-07-01'的字符串转化为日期型数据？谢谢!

[51 byte] By [chequan-chequan] at [2008-1-6]

«« 请问用SOCKET怎样实现在线用户列表
»» EMAIL的验证

# 1

select cast('2006-07-01' as datetime)

hellowork-一两清风 at 2007-10-25 >

top of Msdn China Tech,MS-SQL Server,疑难问题...

# 2

select cast('2006-07-01' as datetime)

simonhehe-流氓会武术,谁也挡不住 at 2007-10-25 >

top of Msdn China Tech,MS-SQL Server,疑难问题...

# 3

谢谢!试试去!

chequan-chequan at 2007-10-25 >

top of Msdn China Tech,MS-SQL Server,疑难问题...

# 4

select convert(datetime,'2006-07-01')

xyxfly-Allthingsaredifficultbeforetheyareeasy. at 2007-10-25 >

top of Msdn China Tech,MS-SQL Server,疑难问题...

MS-SQL Server Hot Topic

MS-SQL Server New Topic