Hi Experts,
How to find the diffrence between two timestamp dates in days. e.q start_activity_date timestamp end_activity_date timestamp select (start_activity_date-end_activity_date ) from table above query given result in interval day to second how can i get in days only. Regards Mayank --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -~----------~----~----~----~------~----~------~--~---