October 21, 2024
Chicago 12, Melborne City, USA
SQL

Convert 1minutes interval data to 5min,15min,30min,1hour interval in oracle sql


  • I have a table which contains data of 1minute time interval of a stock.

  • I need to convert the data into 5min,15min,30min,1hour time intervals and group the columns.

I have no idea how to convert time intervals. Can anyone help me pls.

date open close
27-09-2024 15:25:00 352.85 352.75
27-09-2024 15:26:00 353 351.95
27-09-2024 15:27:00 353.5 352
27-09-2024 15:28:00 354 353



You need to sign in to view this answers

Leave feedback about this

  • Quality
  • Price
  • Service

PROS

+
Add Field

CONS

+
Add Field
Choose Image
Choose Video