sql ÈÕÆÚת»»£¡ - .NET¼¼Êõ / ASP.NET

ÓÉÓÚÇ°ÆÚÉè¼ÆÎÊÌâ ÏÖÔÚ ÓÐÁÐ string ÀàÐÍ 2009-9-9 0£º00£º00 2009Äê9ÔÂ9ÈÕ 2009-9-9 2009-9-9 0£º00
ÕâËÄÖÖ¸ñʽ ÏÖÔÚÏë²éij¶Îʱ¼äÀàµÄÊý¾Ý ÕâÁиÃÔõôת»» convert( datetime , a) or cast(a as datetime )

ºÃÏñÔõôת»»¶¼³ÉÁË1900-01-01 00:00:00.000
?????????

---

string.Format()
ÓÃÕâ¸ö¶¨Ï¸ñʽ

---

ÒýÓÃ

string.Format()
ÓÃÕâ¸ö¶¨Ï¸ñʽ

¸çÃÇ ÎÒ˵ÊÇÔÚsqlÀï

---

declare @a varchar(22)
set @a='2009-9-9 0£º00£º00'
select cast(replace(@a ,'£º',':') as datetime )

set @a='2009Äê9ÔÂ9ÈÕ'
select cast(replace(replace(replace(@a ,'Äê','-'),'ÔÂ','-'),'ÈÕ',' ') as datetime )

ÊÔÊÔÉÏÃæ sql

http://www.mystruggle.com.cn

---

SQL code:

select * from testDate where cast(replace(replace(replace(now,'ÈÕ',''),'ÔÂ','-'),'Äê','-') as datetime)>cast('2009-9-9' as datetime);


ʵÑé³É¹¦ÁË

---

°ÑÄǸönowÌæ»»³É£¬ÄãµÄÄǸöÈÕÆÚ×Ö¶Î

---

ʹÓÃbetween and²éѯ

---

ÒýÓÃ

declare @a varchar(22)
set @a='2009-9-9 0£º00£º00'
select cast(replace(@a ,'£º',':') as datetime )

set @a='2009Äê9ÔÂ9ÈÕ'
select cast(replace(replace(replace(@a ,'Äê','-'),'ÔÂ','-'),'ÈÕ',' ') as datetime ¡­¡­

Õý½â

---

ÒýÓÃ

SQL code

create