add minutes

[specv]

I work with oracle sqlplus. What i want is add minutes on a date field.
Is it possible?

Thanks
Phil

 

[carp]

Absolutely:
SELECT old_date + desired_number_of_minutes/(24*60) new_date
FROM my_table;

It will be faster if you do the math up front to get
SELECT old_date + desired_number_of_minutes/1440 new_date
FROM my_table;