| 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: | Whole Thread | Raw Message | 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 |