28,406
社区成员
发帖
与我相关
我的任务
分享sqlserver的T-SQL转换为oracle8的SQL?
SELECT a.unitno AS unitno,a.pos_id AS posid,b.unitname AS unitname
FROM POS_FILE a,UNIT b
WHERE a.pos_id NOT IN (SELECT DISTINCT pos_id FROM POS_TRADE WHERE tx_time>='2003-01-01' AND tx_time<'2005-09-20')
AND a.unitno*=b.unitno
以上sqlserver的T-SQL如何转换为oracle8的SQL？
FROM POS_FILE a,UNIT b
WHERE a.pos_id NOT IN (SELECT DISTINCT pos_id FROM POS_TRADE WHERE tx_time>='2003-01-01' AND tx_time<'2005-09-20')
AND a.unitno*=b.unitno
以上sqlserver的T-SQL如何转换为oracle8的SQL？
...全文
请发表友善的回复…
发表回复
mymyal123 2005-05-19
- 打赏
- 举报
日期那里要变
to_date('2005-09-20','dd-mm-yyyy')
to_date('2005-09-20','dd-mm-yyyy')
