i have a table which has date and interval.interval contains hourandminute
Interval data is every 30 minute interval.for ex 0,30,100,130,200....1200,1230,1300 like this.

how do i get last 30 minute interval data from select query ?
Please let me know your thoughts

Thank you for your help