oracle中如何查询时间,oracle中通过时间查询内容的问题 - Oracle / 开发

下面是.net上的代码

private void button1_Click(object sender, EventArgs e)

{

DateTime GivenDay = DateTime.Parse(SelectDay.Text.Trim());

Fill_dayview(GivenDay);

}

//用于生成日视图

private int Fill_dayview(DateTime GivenDay)

{

//生成一个新的DataSet

DataSet DS_DayView = new DataSet();

MySchedule DaySchedule = new MySchedule();

if (!DaySchedule.GetScheduleByGivenDay(ref myConn, ref DS_DayView, ref GivenDay))

return -1;

int nScheduleCount = DS_DayView.Tables["ScheduleList"].Rows.Count;

dg_dayview.DataSource = DS_DayView.Tables["ScheduleList"].DefaultView;

return 0;

}

下面是oracle的代码：

CREATE OR REPLACE PROCEDURE GetScheduleGivenDay (GivenDay date)

as

task_title task.title%type;

task_detail task.detail%type;

task_begintime task.begintime%type;

task_notifytime task.notifytime%type;

task_neednotify task.neednotify%type;

task_finished task.finished%type;

tasktype_typetitle tasktype.typetitle%type;

priority_title priority.prioritytitle%type;

begin

select

task.title,

task.detail,

task.