J jlyin Unregistered / Unconfirmed GUEST, unregistred user! 2002-11-25 #1 PARADOX库,在SQL EXPLORER中SQL查询,日期格式是怎样的(当然不能用变量)?我要调试,忘了
J jsxjd Unregistered / Unconfirmed GUEST, unregistred user! 2002-11-25 #2 select Date_open from clients 93-1-1 81-2-7
J jlyin Unregistered / Unconfirmed GUEST, unregistred user! 2002-11-25 #3 不对啊 select * From issucard where paydate<'02-01-02' 没单引号也不对 好象ORACLE是'JAN-01-2002' 是不是有个日期转换函数?
J jsxjd Unregistered / Unconfirmed GUEST, unregistred user! 2002-11-25 #4 select date_open from clients where date_open<'9/3/90' Ok
J jsxjd Unregistered / Unconfirmed GUEST, unregistred user! 2002-11-25 #5 select date_open from clients where date_open<'9/3/2002' also Ok
T twos Unregistered / Unconfirmed GUEST, unregistred user! 2002-11-25 #7 对的,中间用/分割 修改区域设置是没有用的 可以在bde管理器中改