Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Begin time and End time calculation from timestamp

msbOct 1 2013 — edited Oct 1 2013

Dear all,

I have a below input,

Channel_numberGPS_TIME
58152013-05-13 18:56:46.410000
58152013-05-13 18:56:47.410000
58152013-05-13 18:56:48.410000
58152013-05-13 18:56:49.410000
57802013-05-13 18:56:49.510000
57802013-05-13 18:56:50.410000
57802013-05-13 18:56:51.410000
58152013-05-13 18:56:51.510000
58152013-05-13 18:56:52.410000

I am trying to get the output like below,

CHANNEL_NUMBERBEGIN_TIMEEND_TIME
58152013-05-13 18:56:46.4100002013-05-13 18:56:49.410000
57802013-05-13 18:56:49.5100002013-05-13 18:56:51.410000
58152013-05-13 18:56:51.5100002013-05-13 18:56:52.410000

Please help me out to get this.

Thanks All
This post has been answered by Etbin on Oct 1 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 29 2013
Added on Oct 1 2013
3 comments
358 views