Date problem

[clo]

Hi,

I have a field date on a table. The format of the date is the following: "9/12/01 11:14:15 AM". The date stored on the filed is the current date. I'll like to update this field to the next day; I know I can do it by using the expression "SYSDATE + 1". I'll also like to update hour and minutes... How can I do this?

I would really appreciates any suggestions!

 

[fluteplr]

Your question is not very clear but if you are looking to update the datefield by 1 day look at the dateadd function.
If you want to put in the current date and time + 1 day look ad using dateadd along with getdate().