From: kumar <kumar@cc.usu.edu>
To: pgsql-sql@postgresql.org
Subject: Timestamp problem
Date: Tue, 11 Jun 2002 14:40:42 -0600
Message-ID: <3D06EF85@webmail.usu.edu> (raw)
Hai All,
I have been using Mysql in which I used unix_timestamp() function
to retrieve the time using the queries. As it gives time in seconds the life
is easy to store it in database and to compare with the other times. But now I
am moving to PostgreSQL in which there is a function current_timestamp to
retrieve time, but now it became hard for me to store it in database in the
string format and to compare it with other times again.
Is there any function in PostgreSQL which returns time in
seconds like unix_timestamp() in Mysql. Please suggest me some ways to get rid
of this problem.
My email: kumar@cc.usu.edu .
Thank you All,
Kumar.
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 using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: kumar@cc.usu.edu
Subject: Re: Timestamp problem
In-Reply-To: <3D06EF85@webmail.usu.edu>
* 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