i want to store the date at which the record is inserted.I have a lot of data in my database and i want to show the data in the sequence of date . and i want that user see data 2daysbefore or 3days before 4days,9days for this purose which sqlQuery shoud be used and which logic shoud be used.
i do this i got time in seconds through getTime(),function and inserted in to database when a record is inserted both at a time. i want that user can see data twodays before,10daysbefore,---alldata which depends upon user's choice.i can got days by subtra -ctng seconds at which record is inserted by current seconds.and got days but how can update database how can use sql query to display two days record ;10days----allrecords.
posted 14 years ago
This is really more of a database question than a servlet one, so I've moved it to the JDBC forum.