Java开发网 Java开发网
注册 | 登录 | 帮助 | 搜索 | 排行榜 | 发帖统计  

您没有登录

» Java开发网 » Database/JDBC/SQL/JDO/Hibernate  

按打印兼容模式打印这个话题 打印话题    把这个话题寄给朋友 寄给朋友    该主题的所有更新都将Email到你的邮箱 订阅主题
flat modethreaded modego to previous topicgo to next topicgo to back
作者 怎么在Oracle中查询某个年度的数据
gaoxt1983





发贴: 67
积分: 0
于 2006-08-25 11:23 user profilesend a private message to usersearch all posts byselect and copy to clipboard. ie only, sorry for netscape users:-)add this post to my favorite list
有个字段是date型的，现在有个需求是查某个年度的数据，我现在的做法是select xxxx from xxxx where xxx BETWEEN TO_DATE('某年-01-01','yyyy-mm-dd') TO TO_DATE('某年-12-31','yyyy-mm-dd')，这么写太难看了，有没有更好的方法？


作者 Re:怎么在Oracle中查询某个年度的数据 [Re:gaoxt1983]
why

問題兒童

总版主


发贴: 4629
积分: 388
于 2006-08-25 11:34 user profilesend a private message to usersend email to whysearch all posts byselect and copy to clipboard. ie only, sorry for netscape users:-)add this post to my favorite list
use stored procedures to "hide" such "太难看" sql code Smile


作者 Re:怎么在Oracle中查询某个年度的数据 [Re:gaoxt1983]
gaoxt1983





发贴: 67
积分: 0
于 2006-08-25 11:37 user profilesend a private message to usersearch all posts byselect and copy to clipboard. ie only, sorry for netscape users:-)add this post to my favorite list
1.项目不让用sp
2.sp似乎不应该涉及业务逻辑


作者 Re:怎么在Oracle中查询某个年度的数据 [Re:gaoxt1983]
why

問題兒童

总版主


发贴: 4629
积分: 388
于 2006-08-25 13:01 user profilesend a private message to usersend email to whysearch all posts byselect and copy to clipboard. ie only, sorry for netscape users:-)add this post to my favorite list
> 2.sp似乎不应该涉及业务逻辑
This does not seem to be 业务逻辑, but more like reporting stuff.


作者 Re:怎么在Oracle中查询某个年度的数据 [Re:gaoxt1983]
davis_854





发贴: 1
积分: 0
于 2006-08-29 16:15 user profilesend a private message to usersearch all posts byselect and copy to clipboard. ie only, sorry for netscape users:-)add this post to my favorite list
select * from table where to_char(col_date, 'yyyy') = ?


作者 Re:怎么在Oracle中查询某个年度的数据 [Re:gaoxt1983]
why

問題兒童

总版主


发贴: 4629
积分: 388
于 2006-08-29 17:28 user profilesend a private message to usersend email to whysearch all posts byselect and copy to clipboard. ie only, sorry for netscape users:-)add this post to my favorite list
select * from table where TO_NUMBER(to_char(col_date, 'yyyy')) = ?
这么写仍是"太难看"吧? Smile



flat modethreaded modego to previous topicgo to next topicgo to back
  已读帖子
  新的帖子
  被删除的帖子
Jump to the top of page

   Powered by Jute Powerful Forum® Version Jute 1.5.6 Ent
Copyright © 2002-2021 Cjsdn Team. All Righits Reserved. 闽ICP备05005120号-1
客服电话 18559299278    客服信箱 714923@qq.com    客服QQ 714923