Help in Query

[sammy]

I have a table named as emp and in this I have a column named as empdate. I want to insert in this records such that the empdate column is fully filled with tomorrow date that is sysdate+1 along with the time also stored in it for all the rows. I could not get this. How can I do this using SQL query?

[caradoc]

SYSDATE actually gives current date and time along with hours, minutes and seconds. So you can just give

Insert into tablename values (sysdate+1);

This would solve your problem.