I have to retrieve the records in a chronological order.So I need to insert the records using time stamp so that i can compare them and retrieve. I need the syntax of the insert statement.Please help me out in this....
posted 9 years ago
insert into your_table(your_column) values (SYSTIMESTAMP);
Alternately you can use the to_date function to format a Date String of your own for inserting in the data base.. substitute it in place of systimestamp
insert into your_table(your_column) values (to_date(yourString, 'mm/dd/yyyy hh24:mi:ss')) [ December 12, 2007: Message edited by: Paul Campbell ]