- Jun 6, 2020
- 11,559
- 4,422
Hi All.
I have this table:
Through this query, where 4200 are 70 minute:
SQL:
SELECT
data_entrata,
FROM_UNIXTIME((UNIX_TIMESTAMP(data_entrata) DIV 4200) * 4200, '%d-%m-%Y %H:%i')
FROM
test
ORDER BY data_entrata
I wait for the column (the second one you see) to be populated with the same data if it falls within 70 minutes.
Example time 09:15 so I would expect all values up to 10:25 to have the same value (always in the second column)
for the first group of lines that go from 09:15 to 10:20 I would have expected to see the same value, but I don't get this result.
The correct situation should be from:
09:15 to 10:20
and from 10:50 to 11:19
Any suggestions ?
Thank you
I have this table:
برای دیدن تصاویر باید ثبت نام کنید
Through this query, where 4200 are 70 minute:
SQL:
SELECT
data_entrata,
FROM_UNIXTIME((UNIX_TIMESTAMP(data_entrata) DIV 4200) * 4200, '%d-%m-%Y %H:%i')
FROM
test
ORDER BY data_entrata
I wait for the column (the second one you see) to be populated with the same data if it falls within 70 minutes.
Example time 09:15 so I would expect all values up to 10:25 to have the same value (always in the second column)
برای دیدن تصاویر باید ثبت نام کنید
for the first group of lines that go from 09:15 to 10:20 I would have expected to see the same value, but I don't get this result.
The correct situation should be from:
09:15 to 10:20
and from 10:50 to 11:19
برای دیدن تصاویر باید ثبت نام کنید
Any suggestions ?
Thank you
برای دیدن لینک ها باید ثبت نام کنید