OraFAQ Forum: Forms » Date Range During Execute Query

Home » Developer & Programmer » Forms » Date Range During Execute Query

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Date Range During Execute Query [message #87666]

Sun, 30 January 2005 21:27

M Kumar
Messages: 38
Registered: August 2004

Member

Hi All,

Pl. can anybody tell how to extract records from a table in form for a range of date.

Means i want to extract records for CDATE between '01-JAN-05' and '30-JAN-05' and my date field name in the Table is CDATE.

For a single value its fine but for a range of values how to do.

Thanks in advance.
Kumar

Report message to a moderator

Re: Date Range During Execute Query [message #87667 is a reply to message #87666]

Sun, 30 January 2005 21:46

sanjiban
Messages: 10
Registered: January 2005

Junior Member

select * from
where trunc(cdate) >= '01-JAN-2005' AND TRUNC(CDATE) <= '31-JAN-2005';

Report message to a moderator

Re: Date Range During Execute Query [message #87670 is a reply to message #87666]

Mon, 31 January 2005 00:50

sunil joshi
Messages: 3
Registered: January 2005

Junior Member

select * from

where cdate is between trunc(<from_date>) and trunc(<to_date>)

Report message to a moderator

Re: Date Range During Execute Query [message #87671 is a reply to message #87670]

Mon, 31 January 2005 00:52

sunil joshi
Messages: 3
Registered: January 2005

Junior Member

Please ignore my previous message
==================================== try followings
select * from table_name
where cdate is between trunc(from_date) and trunc(to_date)

Report message to a moderator

Re: Date Range During Execute Query [message #87678 is a reply to message #87666]

Mon, 31 January 2005 19:17

me
Messages: 66
Registered: August 2000

Member

SELECT CDATE FROM table WHERE CDATE BETWEEN '01-JAN-05' and '30-JAN-05'

PL. REPLY IF I'M WRONG

REGARDS
ME,MYSELF AND D2K

Report message to a moderator

Previous Topic:	err in attaching custamized menu in frm 6i
Next Topic:	Problem in Report Execution

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 15:14:41 CDT 2024