Sql statement modification time

1, create a test table,

Create table test_date_add(id number, start _ time date, end _ time date);

2. Insert test data

Insert into the test_date_add value (1, to _ date ('2013-05-27 20: 27: 54',' yyyy-mm-dd hh24:mi:ss'), to _ date ('20/kloc-0).

Insert into the test_date_add value (2, to _ date ('2013-05-2715:12: 36',' yyyy-mm-dd hh24:mi:ss'), to _.

Submit;

3. Query the total data in the table, select T. *, rowid from test _ date _ add T；;

4. Write sql, with a start and end date and time of 5 hours, select T. *, start _ time+5/24S 1, end _ time+5/24e1from test _ date _ add t;