how to select between two Dates?..

Karthik K

13y1.6kLearn iOS Programming

Dear Friends,

I would Like to know the query.Which will have the condition is , Two dates Those Date START_DT And END_DT ,I want to

Fetch the data according to the two dates and Current date. The Current date between the two dates .

How to select Data in group of datas..I require query in Oracle Based..

Thanks in advance ,

Karthik.k

10 Replies

Know the answer? Post it — somebody with the same question will find it here.

Iftikar Hussain13y ago
Accepted answer
Hi,
Try like this

SELECT * FROM YourTable
WHERE START_DT>= TO_DATE('13/08/2013', 'dd/mm/yyyy')
AND END_DT<=TO_DATE('13/08/2013', 'dd/mm/yyyy')

Regards,
Iftikar
Karthik K13y ago
Thanks So Much..

SELECT * FROM YourTable
WHERE START_DT<= TO_DATE('13/08/2013', 'dd/mm/yyyy')
OR END_DT>=TO_DATE('13/08/2013', 'dd/mm/yyyy')
Anyway i am using the above code ...i Unable to use Your Procedure..because i want get some field in values from one table so i cant use that one and then i have to insert it to one table ..

i Tested above query its working ..If you find flaws in that ..pls let me know..

Thanks in advance .

-Karthik
Iftikar Hussain13y ago
try like this

IF EXISTS(SELECT 1 FROM YourTable
WHERE START_DT<= TO_DATE('13/08/2013', 'dd/mm/yyyy') AND END_DT>=TO_DATE('13/08/2013', 'dd/mm/yyyy'))
BEGIN
INSERT INTO your other table
END

Regards,
Iftikar
Karthik K13y ago
i have stored two dates in one table namely START_DT AND END_DT ... Those may different date For Ex: 10-8-13 , 30-9-13 ... i Am going to Insert One record in other table according to the Those dates, if its within the two mentioned date ..i will put entry ..otherwise i will not For that , i have use the Current date ..how is Possible ?.. Guide me , Thanks in Advance..
Iftikar Hussain13y ago
if you want to check for different date set different date value for END_DT

SELECT * FROM YourTable
WHERE START_DT<= TO_DATE('13/08/2013', 'dd/mm/yyyy')
AND END_DT>=TO_DATE('20/09/2013', 'dd/mm/yyyy')

Regards,
Iftikar
Karthik K13y ago
SELECT * FROM YourTable
WHERE START_DT<= TO_DATE('13/08/2013', 'dd/mm/yyyy')
AND END_DT>=TO_DATE('13/08/2013', 'dd/mm/yyyy')

i Have changed that Coding Like above
Iftikar Hussain13y ago
are you passing START_DT and END_DT value to the query or just current date?
Karthik K13y ago
Dear Iftikar, That query have 1 problem, It checks the End_dt Properly and not check the Start_dt...For Example i start-dt is 15-8-13 ,End_Dt may be 20-9-13... When i select its not shows me the resultant data.. Just revert me..
Karthik K13y ago
Thanks ,its working fine ..
Sanjeeb Lenka13y ago
try like this

select * from tablename
WHERE trunc(ORDER_DATE) BETWEEN to_date('03-01-2008','MM-DD-YYYY') AND TO_DATE('03-11-2008','MM-DD-YYYY')