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.
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? |
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 |