From: Stephan Szabo <sszabo@megazone23.bigpanda.com>
To: kumar <kumar@cc.usu.edu>
Cc: pgsql-sql@postgresql.org
Subject: Re: Timestamp problem
Date: Wed, 12 Jun 2002 07:57:46 -0700 (PDT)
Message-ID: <20020612075641.H90949-100000@megazone23.bigpanda.com> (raw)
In-Reply-To: <3D06EF85@webmail.usu.edu>
On Tue, 11 Jun 2002, kumar wrote:
> 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.
What is the specific problem you're having? Do you have an example that
illustrates it?
In general, I don't know why you'd want to store the timestamp as a string
rather than a timestamp.
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: sszabo@megazone23.bigpanda.com, kumar@cc.usu.edu
Subject: Re: Timestamp problem
In-Reply-To: <20020612075641.H90949-100000@megazone23.bigpanda.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