SQLize Online / PHPize Online  /  SQLtest Online

WITH birthdays ( bd_timestamp, bd_unix_epoch ) AS ( VALUES ('2017-10-01', 1506816000), ('2017-10-25', 1508889600), ('2017-10-26', 1508976000), ('2017-10-31', 1509408000), ('2017-10-28', 1509148800), ('2017-11-23', 1511395200), ('2017-11-10', 1510272000), ('2018-12-23', 1545523200), ('2018-12-10', 1544400000), ('2020-01-23', 1579737600), ('2020-01-10', 1578614400), ('2020-02-23', 1582416000), ('2020-02-10', 1581292800), ('2020-09-23', 1600819200), ('2020-09-10', 1599696000), ('2020-09-27', 1601164800) ) SELECT bd_timestamp, bd_unix_epoch FROM birthdays ORDER BY ( CASE WHEN to_char( to_timestamp( bd_unix_epoch ), 'mmd' ) :: int4 - to_char( now( ), 'mmd' ) :: int4 < 0 THEN 20000 + to_char( to_timestamp( bd_unix_epoch ), 'mmd' ) :: int4 - to_char( now( ), 'mmd' ) :: int4 ELSE to_char( to_timestamp(bd_unix_epoch), 'mmd' ) :: int4 - to_char( now( ), 'mmd' ) :: int4 END );