date storage and retrival in mysql

[abyinsydney]

greetings fellow citizens
could any tell me the format to upload date in mysql database. and retrive the data between these dates


i've to upload date from a text file to my sql databse and then rerive the records between the two dates

thnax in advance
aby

 

[sedj]

Eg :

PreparedStatement ps = connection.prepareStatement("insert into login_table values (?,?,?)");
ps.setString(1,"Dave");
ps.setString(2,"Jones");
ps.setTimestamp(3,new java.sql.Timestamp(System.currentTimeMillis());
boolean success = ps.execute();