Hi all,
I'm pretty new to SQL so I only know some of the basic stuffs. I created two columns BEGIN and END both have a TIMESTAMP as datatype. Now. my question is how could I get the diference between these two times/date, meaning the duration between the BEGIN and the END. For example is shown below
Begin
15-NOV-07 08.52.00.000000 AM
End
16-NOV-07 08.58.01.000000 AM
Could you please give some ideas or is/are there any functions that can be used? I'm using ORACLE 10 as a databse. Thank you in advance.
Cordially,
Babe1898
I'm pretty new to SQL so I only know some of the basic stuffs. I created two columns BEGIN and END both have a TIMESTAMP as datatype. Now. my question is how could I get the diference between these two times/date, meaning the duration between the BEGIN and the END. For example is shown below
Begin
15-NOV-07 08.52.00.000000 AM
End
16-NOV-07 08.58.01.000000 AM
Could you please give some ideas or is/are there any functions that can be used? I'm using ORACLE 10 as a databse. Thank you in advance.
Cordially,
Babe1898