to_days(now())

From: Brian Aker <brian(at)tangent(dot)org>
To: pgsql-novice(at)postgresql(dot)org
Subject: to_days(now())
Date: 2000-11-28 21:12:29
Message-ID: 3A241FBD.ACA31525@tangent.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice

Hi all.
I've been looking for a good reference for the built
in time functions and have yet to find any.
What I really need is something similar to MySQL's:
select to_days(now());

This returns the number of days since year one from
the current time in the database.
Thanks for any help in advance (please CC me directly
since I don't subscribe to this mailing list).

-Brian

--
_______________________________________________________
Brian Aker, brian(at)tangent(dot)org
Slashdot Senior Developer
Seattle, Washington
http://tangent.org/~brian/
http://slashdot.org/
_______________________________________________________
You can't grep a dead tree.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2000-11-28 21:28:41 Re: Create View failing
Previous Message Peter Eisentraut 2000-11-28 21:08:57 Re: sgmlspl?

Browse pgsql-novice by date

  From Date Subject
Next Message Nabil Sayegh 2000-11-28 23:43:49 How many users may be created ?
Previous Message Diego A. Puertas F. 2000-11-28 20:15:54 Autentication and ODBC