ÇóÒ»¸ösqlÓï¾ä

a±í
id  name  dateTime
1    aa    2009-9-9
2    bb    2009-9-10
3    cc    2009-9-11
4    dd    2009-9-44
5    jj    2009-9-10
²éѯÁÐdateTimeÖеÄÖµ2009-9-11ÒÔºóµÄÖµ
Ó¦¸ÃÔõôд°¡

---

select * from table where dateTime > to_date('2009-9-11','yyyy-m-dd')

---

select * from a where datediff(day,dateTime,'2009-9-11') <0

---

¿ÉÒÔ£¬Ö§³Ö

---

ͬÒâ¶þÂ¥

---

1Â¥µÄòËÆÊÇOracleÀïµÄsqlÓï¾ä°É
2Â¥µÄû¼û¹ý£¬Ñ§Ï°Ò»ÏÂ!

---

4    dd    2009-9-44

Êý¾Ý¿âÓÐÕâ¸öÖµÂð£¿

---

String ÀàÐ͵Ļ°£¬Ö±½Ó>¾ÍÐÐÁË

---

select * from table where id>(select id from table where dateTime="2009-9-11")

---

string ÀàÐ͵Ļ° Ö±½Ó>¾ÍÐжî

---

select * from table where dateTime > to_date('2009-9-11','yyyy-m-dd')
Õâ¸ö½á¹û»á°Ñ2009-9-11ÄÇÌìµÄ½á¹û²é³ö°É¡£
select * from table where dateTime > to_date('2009-9-11 23:59:59','yyyy-m-dd hh24:mi:ss')

---

select * from table where dateTime > to_date('2009-9-11','yyyy-m-dd')

---

ѧϰÁË£¡

---

Èç¹ûdateTime ÊÇʱ¼äÀàÐ͵Ļ°ÐèҪת»»±È½ÏÏ£¬Èç¹ûÊÇ×Ö·û´®µÄ»°ÄǾÍÖ±½Ó´óÓÚ¾ÍÐÐÁË
select * from table where dateTime > to_date('2009-09-11','yyyy-mm-dd')

{{----}