Karel Zak wrote:
> On Wed, Mar 21, 2001 at 06:20:21PM +0100, Feite Brekeveld wrote:
> > Hi,
> >
> > I need to convert thisone into an integer timestamp value:
> >
> > 14:57:55.540 UTC Sun Mar 4 2001
> >
> > How to deal with the milliseconds part (.540) and the timezone UTC ?
>
> Not implmented yet. In 7.2...
... I've found out that ...
tmp_string := '14:57:55.540 UTC Sun Mar 4 2001';
date_part(''epoch'', cast(tmp_string AS DATETIME))
will do the job.
I've got 3600 seconds difference but that probably has to do with my
timezone.
Feite
>
>
> Karel
>
> --
> Karel Zak <zakkr@zf.jcu.cz>
> http://home.zf.jcu.cz/~zakkr/
>
> C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://www.postgresql.org/search.mpl
--
Feite Brekeveld
feite.brekeveld@osiris-it.nl
http://www.osiris-it.nl
---------------------------------------------------------------------------
Whenever you buy a stock be ready to ride the bull and never get eaten by
the bear.