question

Sandeepkonnam avatar image
Sandeepkonnam asked

SQL oracle

I have a requirement where I have list of records in table with I'd and timestamp....I need to fetch the latest record which is 30 minutes from the latest timestamp.... Need an oracle query for same

Example

1  21- feb-2018 9:00
2  21- feb-2018 8:46  
3  21- feb-2018 8.48
4  21- feb-2018 8.30
15 21- feb-2018 8.25

Output

421- feb-2018 8.30

Any help please

sqloracle
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

KenJ avatar image KenJ commented ·

what have you tried so far? Are you familiar with timestampdiff (https://docs.oracle.com/cd/E17952_01/mysql-5.6-en/date-and-time-functions.html#function_timestampdiff)?

0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.