我在Access 的其一個field 的類型是datetime. 這是其中的一個值  2004/10/15 下午 12:00:00    假設我有1個string time='2004/09/16 03:00:00'    我用SQL statement 'select * from record where datetime >=#' + time + '#' 會出現:     我不想改動database和我作比較時不想比較'上午和下午',我應該如何寫? 發表人 - tidal 於 2004/11/03 12:38:57 發表人 - tidal 於 2004/11/03 12:40:29

Hi tidal,    Access 不太熟，有錯勿怪！

select * from employee where hire_date > #2004/09/16 03:00:00#

---------------------------------- 小弟才疏學淺，若有謬誤尚請不吝指教 ----------------------------------

------
Fishman

您好﹗    插個花 time屬于保留字﹐故建議您不要使用保留字做為變數名稱﹒

例﹕
Var
  MyTime: String;
begin
  MyTime='2004/09/16 03:00:00'
  ADOQuery1.Close;
  ADOQuery1.SQL.Clear;
  ADOQuery1.SQL.Add('Select * From Record Where ');
  ADOQuery1.SQL.Add('DateTime >= ''#' MyTime '#''');
  ADOQuery1.Open;
end;

========================= 我是您的朋友﹐有您真好﹗ ========================= 發表人 - cashxin2002 於 2004/11/03 13:00:07

------
忻晟

補充： *使用字串轉日期時間可以用 'Select * from record where datetime >=DATEVALUE(''' Datetostr(EnCodeDate(2004,9,16)) ''')' ' TIMEVALUE (''' TimetoStr(EnCodeTime(3,0,0,0)) ''')' [保留字一覽表] A ABSOLUTE ANY ADD ARE ADMINDB AS ALL ASC Alphanumeric — 參閱 TEXT ASSERTION ALTER AUTHORIZATION ALTER TABLE AUTOINCREMENT — 參閱 COUNTER And Avg AS B-C BEGIN COLLATION Between COLUMN BINARY COMMIT BIT COMP, COMPRESSION BIT_LENGTH CONNECT BOOLEAN — 參閱 BIT CONNECTION BOTH CONSTRAINT, CONSTRAINTS BY CONTAINER BYTE CONTAINS CASCADE CONVERT CATALOG Count CHAR, CHARACTER — 參閱 TEXT COUNTER CHAR_LENGTH CREATE CHARACTER_LENGTH CURRENCY CHECK CURRENT_DATE CLOSE CURRENT_TIME CLUSTERED CURRENT_TIMESTAMP COALESCE CURRENT_USER COLLATE CURSOR D DATABASE DISALLOW DATE — 參閱 DATETIME DISCONNECT DATETIME DISTINCT DAY DISTINCTROW DEC, DECIMAL DOMAIN DECLARE DOUBLE DELETE DROP DESC E-H Eqv FOREIGN EXCLUSIVECONNECT FROM EXEC, EXECUTE FROM Clause EXISTS GENERAL — 參閱 LONGBINARY EXTRACT GRANT FALSE GROUP FETCH GUID FIRST HAVING FLOAT，FLOAT8 - 參閱 DOUBLE HOUR IEEESINGLE - 參閱 SINGLE I IDENTITY INPUT IEEEDOUBLE — 參閱 DOUBLE INSENSITIVE IEEESINGLE — 參閱 SINGLE INSERT IGNORE INSERT INTO IMAGE INT，INTEGER，INTEGER4 - 參閱 LONG Imp INTEGER1 - 參閱 BYTE In SMALLINT - 參閱 SHORT IN INTERVAL INDEX INTO INDEXCREATEDB Is INNER ISOLATION J-M JOIN LONGTEXT KEY LOWER LANGUAGE MATCH LAST Max LEFT MEMO — 參閱 LONGTEXT Level* Min Like MINUTE LOGICAL，LOGICAL1 - 參閱 BIT MOD LONG MONEY — 參閱 CURRENCY LONGBINARY MONTH LONGCHAR N-P NATIONAL Outer* NCHAR OUTPUT NONCLUSTERED OWNERACCESS Not PAD NTEXT PARAMETERS NULL PARTIAL NUMBER — 參閱 DOUBLE PASSWORD NUMERIC — 參閱 DECIMAL PERCENT NVARCHAR PIVOT OCTET_LENGTH POSITION OLEOBJECT — 參閱 LONGBINARY PRECISION ON PREPARE OPEN PRIMARY OPTION PRIVILEGES Or PROC, PROCEDURE ORDER PUBLIC Q-S REAL — 參閱 SINGLE SMALLDATETIME REFERENCES SMALLINT — 參閱 SHORT RESTRICT SMALLMONEY REVOKE SOME RIGHT SPACE ROLLBACK SQL SCHEMA SQLCODE, SQLERROR, SQLSTATE SECOND StDev SELECT StDevP SELECTSCHEMA STRING — 參閱 TEXT SELECTSECURITY SUBSTRING SET Sum SHORT SYSNAME SINGLE SYSTEM_USER SIZE T-Z TABLE UPDATEOWNER TableID* UPDATESECURITY TEMPORARY UPPER TEXT USAGE TIME — 參閱 DATETIME USER TIMESTAMP USING TIMEZONE_HOUR VALUE TIMEZONE_MINUTE VALUES TINYINT Var TO VARBINARY — 參閱 BINARY TOP VARCHAR — 參閱 TEXT TRAILING VarP TRANSACTION VARYING TRANSFORM VIEW TRANSLATE WHEN TRANSLATION WHENEVER TRIM WHERE TRUE WITH UNION WORK UNIQUE Xor UNIQUEIDENTIFIER YEAR UNKNOWN YESNO — 參閱 BIT UPDATE ZONE UPDATEIDENTITY

wameng 大大 它說timevalue 沒有預設值

不好意思！眼花花 'Select * from record where datetime >=DATEVALUE(''' Datetostr(EnCodeDate(2004,9,16)) ''')' ' TIMEVALUE(''' TimetoStr(EnCodeTime(3,0,0,0)) ''')'; TIMEVALUE後面沒有 ' '

感謝 wameng 大大, 問題解決了 發表人 - tidal 於 2004/11/03 15:19:32