Hello Gayathri,
Assuming FLD_DATE is of type DATE you can write a simple select query to retrieve the data. The below example shows how you can write such query in oracle.
SELECT * FROM YOUR_TABLE WHERE FLD_DATE >= TO_DATE('01/JAN/2013', 'DD/MON/YYYY')
If you are calling this query from .NET front-end then you will be using
DBCommand
in which case the string value(User Input) will be first converted to a Date type variable and then that converted value will be passed to the
DBCommand
as a parameter. Below snippet shows how it can be done in C# using
Oracle Data Provider for .NET[
^].
OracleConnection con;
OracleCommand cmd;
OracleParameter prm;
OracleDataReader reader;
con = new OracleConnection();
con.ConnectionString = "User Id=scott;Password=tiger;Data Source=oracle";
con.Open();
cmd = new OracleCommand("SELECT * FROM TABLE_FOO WHERE fld_date >= :filtDate");
prm = new OracleParameter("filtDate", OracleDbType.Varchar2);
prm.Direction = ParameterDirection.Input;
prm.value = dtFilter;
cmd.Parameters.Add(prm);
reader = cmd.ExecuteReader();
reader.Dispose();
cmd.Dispose();
Regards,