sql ÎÊÌâ

Êý¾Ý¿âÊÇinformix£¬ÓÐÒ»¸ö±ítest£¬ÆäÖÐÓиöinputtime×ֶΣ¬ÊÇDATETIME YEAR TO SECONDÀàÐ͵ģ¬ÎÒÏëÎÊÒ»ÏÂÈçºÎʵÏÖÏÂÃæµÄsql£¿
sql£º
select inputtime,name
from test
where inputtime between '2008/01/01' and '2008/01/02';
ÕâÑùÖ´ÐÐsql±¨´í£ºNon-numeric character in datetime or interval.
ÇëÎÊÈçºÎ½â¾ö£¿¼±£¡Ð»Ð»£¡£¡£¡

---

select inputtime,name
from test
where
TO_CHAR(inputtime,'%Y-%m-%d') between '2008-01-01' and '2008-01-02'

---

ÇëÎÊÓÐÈËÖªµÀ¸ÃÔõô½â¾öÂ𣿱Ƚϼ±£¬Çë´ó¼Ò°ï°ï棬лл£¡£¡£¡

---

TO_CHAR(today,'%D') 08/10/09
TO_CHAR(today,'%y-%m-%d') 09-08-10
TO_CHAR(today,'%Y-%m-%d') 2009-08-10
TO_CHAR(today,'%A %B %d %Y') Monday August 10 2009

---

ÒýÓÃ

select inputtime,name
from test
where
TO_CHAR(inputtime,'%Y-%m-%d') between '2008-01-01' and '2008-01-02'

ÕâÑù¿ÉÒÔ½â¾ö±¨´íµÄÎÊÌ⣬¿ÉÊÇÂú×ãÌõ¼þµÄ¼Ç¼ȴ²é²»³öÀ´£¡ÓÃ4Â¥µÄ·½·¨¿ÉÒÔ½â¾ö´ËÎÊÌ⣡²»¹ý»¹ÊÇҪллÄ㣡£¡£¡

---

ÒýÓÃ

wheredate(inputtime) between '2008/01/01' and '2008/01/02'

ÓÃÕâ¸ö·½·¨¿ÉÒÔ½â¾öÁË£¬Ð»Ð»£¡£¡£¡

---

СÉùÎÊһϣ¬¿ÉÒÔÄÃ100£¿

---

ÒýÓÃ

СÉùÎÊһϣ¬¿ÉÒÔÄÃ100£¿

ÎÒ¸øÄã80·Ö°É£¬1Â¥Ò²°ï