database

[123 456]

how can i fetch date type of data from oracle database?

[r035198x]

Same way you get other types.

select columnName from tableName

What problem are you getting exactly?

[123 456]

Actually i am entering date from keyboard and try to fetch it

String sql= "select * from LogTable3 where logDate="+date;

i am taking date as a user input, but its not working

[r035198x]

What programming language are you using and what type is that date variable that you adding to the query?

[123 456]

i am using java and date variable i am taking as Date object

[r035198x]

You need to brush up on your JDBC. You don't set date parameters like that. You set them on a PreparedStateme nt

String sql= "select * from LogTable3 where logDate=?";
preparedStatement.setDate(1, date);

[123 456]

i am setting it by using statement obj bro...

[r035198x]

I don't understand. You just said that you set it using

String sql= "select * from LogTable3 where logDate="+date;

above. That is not setting it using statement.

[123 456]

String date= "25-jun-2012";
Statement stmt1= connection.crea teStatement();
String sql= "select * from LogTable3 where logDate="+date;
ResultSet rs1= stmt1.executeQu ery(sql);

now u understand or not?

[r035198x]

1.) You said "date variable i am taking as Date object ". But you have

String date= "25-jun-2012";

That is a string not a date.
2.) Don't ever use Statement. Use PreparedStateme nt instead because
a.)PreparedStat ement will cache the compiled query on the database and so will be faster for multiple invocations
b.)PreparedStat ement protects against SQL injection.
3.) You should create a java.sql.Date object to set as the parameter in your prepared statement. You change the String to a Date using the SimpleDateForma t class, something like

date = new SimpleDateFormat("MM-dd-yyyy").parse("25-06-2012");
PreparedStatement ps = connection.prepareStatement(sql);	    ps.setDate(1, new java.sql.Date(date.getTime()));