| From: | Jonathan Gardner <jgardner(at)jonathangardner(dot)net> |
|---|---|
| To: | teknokrat(at)yahoo(dot)com, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: converting interval to timestamp |
| Date: | 2003-08-08 16:22:01 |
| Message-ID: | 200308080922.02513.jgardner@jonathangardner.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On Thursday 31 July 2003 09:05, teknokrat wrote:
> The difference of two dates/timestamps always gives an interval. is
> there a way to convert this interval into number such as number of
> milliseconds or number of days?
>
Take a look at the User's Guide. There is great documentation on the available
functions to manipulate and extract useful information from dates and
timestamps.
I think the function you are looking for is "extract".
> Also does anyone know what field type an interval would map to in jdbc?
>
Post this question it the interfaces list. I am sure they would be more
helpful.
- --
Jonathan Gardner <jgardner(at)jonathangardner(dot)net>
Live Free, Use Linux!
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)
iD8DBQE/M84pWgwF3QvpWNwRAnOiAKC9t3rZNve8KyOgXyxMG/p75OxkTwCeP+Tv
ZYuvijykpHJ3GZiwD6hIvnI=
=onBr
-----END PGP SIGNATURE-----
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jonathan Gardner | 2003-08-08 16:24:48 | Re: Analyze makes queries slow... |
| Previous Message | Stephan Szabo | 2003-08-08 15:52:30 | Re: [pg-sql] - Problem with duplicate table (PostgreSQL 7.2.3 |