Typ så här? Kod körd
22:32.
Kod:
SELECT
dt as dt_datetime,
unix_timestamp(dt) as dt_unix,
abs(unix_timestamp(now()) - unix_timestamp(dt)) AS diff_from_now
FROM test
ORDER by diff_from_now
Output
Kod:
dt_datetime dt_unix diff_from_now
2010-01-11 23:00:00 1263247200 1640
2010-01-11 22:00:00 1263243600 1960
2010-01-12 00:00:00 1263250800 5240
2010-01-11 21:00:00 1263240000 5560
2010-01-12 01:00:00 1263254400 8840
2010-01-11 20:00:00 1263236400 9160
2010-01-11 19:00:00 1263232800 12760
2010-01-11 18:00:00 1263229200 16360
