Plzzz help regarding this......

[bsonline]

I hv a datetime format like '24/01/2008 15:56:01' . Now I have to select dates from a date range, but input datetime format like 24/1/2008 15:56:01'.
I hv written the query like :

"select date_column from date_table where to_char(date_column,'dd/mm/yyyy hh24:mi:ss') between input_date and input_date; "

here I face a problem that when the date range within a month, it works fine.
but when it become greater may be 2 or 6 month date range it does not work...

Plzzz help regarding this......

[debasisdas]

try to use this

select date_column from date_table where date_column between to_char(input_date,'dd/mm/yyyy hh24:mi:ss') and to_char(input_date1,'dd/mm/yyyy hh24:mi:ss')

[bsonline]

try to use this

select date_column from date_table where date_column between to_char(input_date,'dd/mm/yyyy hh24:mi:ss') and to_char(input_date1,'dd/mm/yyyy hh24:mi:ss')

I have get the error :.. "ORA-01722: invalid number"

[debasisdas]

I have get the error :.. "ORA-01722: invalid number"

just rry to pass the inoput date in this format

SELECT * FROM table_name WHERE to_char(date_field,'dd-mon-yyyy hh24:mi:ss') BETWEEN '01-jan-1991 01:02:03' AND '31-dec-1998 23:05:34';
 

[subashsavji]

Select Hiredate,to_date(to_char(hiredate,'dd/mm/yy Hh24:mi:ss'),'dd/mm/yy Hh24:mi:ss') From Emp
Where Hiredate Between To_char('12-01-80','dd/mm/yy Hh24:mi:ss') And To_char(sysdate,'dd/mm/yy Hh24:mi:ss')