SQL SERVER6.5，怎么用SQL语句得到一个datetime类型变量所对应的日期(100分)

C

CoWo

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-05-01

• #1

比如
2001-4-30 00:00.000----->2001-4-30

 

H

han

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-05-01

• #2

select convert(varchar,(datepart(yy,yourdatetime)))+'-'
+convert(varchar,(datepart(mm,yourdatetime)))+'-'+
+convert(varchar,(datepart(dd,yourdatetime))) date

 

C

CoWo

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-05-01

• #3

接受答案了.