Re: Unixtime function?...

On Wed, May 02, 2001 at 08:49:32AM -0700, Richard Whittaker wrote:
> In MySQL there is a function to convert an arbitrary date/time combination
> to a Unix timestamp, which makes it really easy to perform calculations in
> PHP, since the result was always an integer... Is there a similar function
> out there for PostgresSQL or PHP?...

well in php you can use date(),
http://www.php.net/manual/en/function.date.php

and all the time functions in php
http://www.php.net/manual/en/ref.datetime.php

and in postgres you can use functions like date_part()
http://www.postgresql.org/docs/aw_pgsql_book/node92.html#7786

that would be a good start.

./muk

--
Matthew Kolb
muk(at)phaedrus(dot)gaslightmedia(dot)com