From: Rommel B. Abaya <rommel.abaya@ramcargroup.com>
To: zlatko@iskon.hr
Cc: pgsql-sql@postgresql.org
Cc: pgsql-general@postgresql.org
Subject: Re: Porting from mysql to psql (UNIX_TIMESTAMP()?)
Date: Sat, 09 Sep 2000 19:25:59 +0800
Message-ID: <39BA1E47.94398377@ramcargroup.com> (raw)
References: <874s3p3k1c.fsf@atlas.iskon.hr>
i thick it's epoch() in PostgreSQL....check your documentation.
Zlatko Calusic wrote:
> Hi!
>
> As subject says, we are currently porting all of our data, programs
> and logic from mysql to postgresql. One of the things we have yet to
> resolve is how to replace mysql's UNIX_TIMESTAMP() function we used
> extensively in PosgreSQL?
>
> Function works like this in mysql:
>
> mysql> select start from connection limit 1;
> +---------------------+
> | start |
> +---------------------+
> | 2000-07-03 20:12:37 |
> +---------------------+
> 1 row in set (0.01 sec)
>
> mysql> select UNIX_TIMESTAMP(start) from connection limit 1;
> +-----------------------+
> | UNIX_TIMESTAMP(start) |
> +-----------------------+
> | 962647957 |
> +-----------------------+
> 1 row in set (0.00 sec)
>
> Is there any similar functionality (returning unixish number of
> seconds since 1970 from the timestamp field) in PostgreSQL?
>
> I tried all of the available date/time functions, type casting but all
> to no avail.
>
> TIA,
> --
> Zlatko
>
> P.S Is it bad manners crossposting to two pgsql mailing list? Still
> new to PostgreSQL, still learning...
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: rommel.abaya@ramcargroup.com, zlatko@iskon.hr, pgsql-general@postgresql.org
Subject: Re: Porting from mysql to psql (UNIX_TIMESTAMP()?)
In-Reply-To: <39BA1E47.94398377@ramcargroup.com>
References: <874s3p3k1c.fsf@atlas.iskon.hr> <39BA1E47.94398377@ramcargroup.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox