請教一個SQL 指令問題： 我有一個資料庫，其內容如下範例： FDate FTime --------------------------- 2003/4/1 00:10:01 AM 2003/4/1 01:10:01 AM 2003/4/1 02:10:01 AM 2003/4/1 03:10:01 AM 2003/4/1 04:10:01 AM 2003/4/1 05:10:01 AM 2003/4/1 12:10:01 PM 2003/4/1 01:10:01 PM 2003/4/1 03:10:01 PM 2003/4/1 08:10:01 PM 2003/4/1 10:10:01 AM 2003/4/1 11:10:01 AM 2003/4/2 00:10:01 AM 2003/4/2 01:10:01 AM 2003/4/2 02:10:01 AM 2003/4/2 03:10:01 AM 2003/4/3 00:10:01 AM 2003/4/3 01:10:01 AM 2003/4/3 02:10:01 AM 2003/4/3 03:10:01 AM ...... 我如果想要抓取2003/4/1 02：00：01 AM 至 2003/4/3 01：59：59 AM 這段其間的資料或許會更久，可能五天或十天這樣的期間，不知該如何下SQL指令。

不同資料庫的語法稍有不同，簡單來說就是在 where 裡 把 FDate 變成字串 FTime 變成字串 來與你的條件作字串對比，要記得使用年月日時分秒的格式來對比就可以了。若你不知你使用的資料庫要甚樣做，可說出你的資料庫等大家幫你。

請看藍字 ↓     資料庫種類繁多, 記得先說用啥資料庫喔

引言: 請看藍字 ↓ 資料庫種類繁多, 記得先說用啥資料庫喔

=================================== 我用的資料庫是PARADOX DB

節錄一段 Local SQL Help :

Description    Use the BETWEEN comparison predicate to compare a value to a value range. If the value is greater than or equal to the low end of the range and less than or equal to the high end of the range, BETWEEN returns a TRUE value. If the value is less than the low end value or greater than the high end value, BETWEEN returns a FALSE value. For example, the expression below returns a FALSE value because 10 is not between 1 and 5.    10 BETWEEN 1 AND 5    Use NOT to return the converse of a BETWEEN comparison. For example, the expression below returns a TRUE value.    10 NOT BETWEEN 1 AND 5    BETWEEN can be used with all non-BLOB data types, but all values compared must be of the same or a compatible data type. If one value is of an incompatible data type, convert that value with the CAST function to a compatible data type. Values used in a BETWEEN comparison may be column, literal, or calculated values.    SELECT Saledate    FROM Orders    WHERE (Saledate BETWEEN "1/1/1988" AND "12/31/1988")

Hi, 請試試: Select * from Table1 where (FDate = '2003/4/1' and FTime >= '02:00:01' ) or (FDate > '2003/4/1' and FDate < '2003/4/3') or (FDate = '2003/4/3' and FTime <= '01:59:59' ) 以此類推. 僅頭尾要定出時間範圍, 中間段定出日期範圍即可, 如: 抓取2003/4/1 02：00：01 AM 至 2003/4/10 01：59：59 AM 則可用: Select * from Table1 where (FDate = '2003/4/1' and FTime >= '02:00:01' ) or (FDate > '2003/4/1' and FDate < '2003/4/10') or (FDate = '2003/4/10' and FTime <= '01:59:59' )

引言: Hi, 請試試: Select * from Table1 where (FDate = '2003/4/1' and FTime >= '02:00:01' ) or (FDate > '2003/4/1' and FDate < '2003/4/3') or (FDate = '2003/4/3' and FTime <= '01:59:59' ) 以此類推. 僅頭尾要定出時間範圍, 中間段定出日期範圍即可, 如: 抓取2003/4/1 02：00：01 AM 至 2003/4/10 01：59：59 AM 則可用: Select * from Table1 where (FDate = '2003/4/1' and FTime >= '02:00:01' ) or (FDate > '2003/4/1' and FDate < '2003/4/10') or (FDate = '2003/4/10' and FTime <= '01:59:59' )

================================================ 感謝，這就是我要的答案。