Date Extraction help.

[lalitkgehlot89]

Hi,

I have a table and Data is coming after every 10 second, due to large data application is getting slow.

I want to put the condition while extracting the data should be every 2 minutes only rather than every second?

data set record would be like this

01.01.01 12:00:00

01.01.01 12:00:10

01.01.01 12:00:20

01.01.01 12:00:30

01.01.01 12:00:40

01.01.01 12:00:50

01.01.01 12:01:00

01.01.01 12:01:10

01.01.01 12:01:20

01.01.01 12:01:30

01.01.01 12:01:40

01.01.01 12:01:50

01.01.01 12:02:00

01.01.01 12:02:10

01.01.01 12:02:20

01.01.01 12:02:30

01.01.01 12:02:40

01.01.01 12:02:50

01.01.01 12:03:00

01.01.01 12:03:10

01.01.01 12:03:20

01.01.01 12:03:30

01.01.01 12:03:40

01.01.01 12:03:50

01.01.01 12:04:00

01.01.01 12:04:10

01.01.01 12:04:20

01.01.01 12:04:30

01.01.01 12:04:40

01.01.01 12:04:50

01.01.01 12:05:00

01.01.01 12:05:10

01.01.01 12:05:20

01.01.01 12:05:30

01.01.01 12:05:40

01.01.01 12:05:50

01.01.01 12:06:00

01.01.01 12:06:10

01.01.01 12:06:20

01.01.01 12:06:30

01.01.01 12:06:40

01.01.01 12:06:50

01.01.01 12:07:00

01.01.01 12:07:10

01.01.01 12:07:20

01.01.01 12:07:30

01.01.01 12:07:40

01.01.01 12:07:50

output require like records would be

01.01.01 12:00:00

01.01.01 12:02:00

01.01.01 12:04:00

01.01.01 12:06:00

and so on.

Pls suggest

[sunny_talwar]

May be explore here: Rounding time to nearest hourly quarter | Oracle Community

[Gysbert_Wassenaar]

I was trying to be subtle to give you a chance to ninja-edit 24*60 into 24*30

[sunny_talwar]

I used 2 in the numerator.

I used 2/(24* 60) = 1/(24*30)

[Gysbert_Wassenaar]

Bah, I should retire. I'm getting senile ...and blind

[sunny_talwar]

Retiring is not an option Gysbert‌, we still need your expertise here