server语言转成oracle与然 - Oracle / 开发

本人只学过oracle，现在做练习，里面有一段server语句不知道怎么理解，请高手帮忙把这段代码改成oracle的代码，谢谢了



create procedure GetScheduleGivenDay @GivenDay datetime
as

select 
  task.title,
  task.detail,
  task.begintime,
  task.notifytime,
  task.neednotify,
  task.finished,
  tasktype.typetitle,
  priority.prioritytitle
from tasktype
  INNER JOIN task ON Task.Type.TaskType_ID=task.type
  INNER JOIN priority ON task.priority=priority.priority_ID
where 
  (DAY(@GivenDay)=DAY(task.BeginTime))
  AND
  (MONTH(@GivenDay)=MONTH(task.BeginTime))
  AND
  (YEAR(@GivenDay)=YEAR(task.BeginTime))
RETURN
GO

---

引用

本人只学过oracle，现在做练习，里面有一段server语句不知道怎么理解，请高手帮忙把这段代码改成oracle的代码，谢谢了



create procedure GetScheduleGivenDay @GivenDay datetime
as

select
task.title,
task.detail,
task.begintime,
task……

看来你应该到server板块去问赛。

呵呵

---

datetime改成date