Assuming that I have a table that has a time stamp on column called time. And I want to update
this column with date and time e.g (02/22/2001 and time is 1 :24 pm) how do I do that?

2.What if I want update that same column with the same date but this time with
sysdate instead of the specified time.

Can any one please show me the syntax for these 2 examples?

thanks,