Привет.

Нужен аналог MySQL функции TO_DAYS(date), кторая показывает количество дней, начиная с 0 года.

TO_DAYS(date)

Given a date date, returns a daynumber (the number of days since year 0).

mysql> SELECT TO_DAYS(950501);
-> 728779
mysql> SELECT TO_DAYS('1997-10-07');
-> 729669

TO_DAYS() is not intended for use with values that precede the advent of the Gregorian calendar (1582), because it does not take into account the days that were lost when the calendar was changed.

Remember that MySQL converts two-digit year values in dates to four-digit form using the rules in Section 11.3, “Date and Time Types”. For example, '1997-10-07' and '97-10-07' are seen as identical dates:


mysql> SELECT TO_DAYS('1997-10-07'), TO_DAYS('97-10-07');
-> 729669, 729669


For other dates before 1582, results from this function are undefined.


Как это можно реализовать в postges?

st_sergselect extract(epoch from now()) / (60*60*24);
?

Спасибо, буду вертеть :)