Re: Hour difference?

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Bjørn T Johansen <btj(at)havleik(dot)no>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Hour difference?
Date: 2003-08-18 16:17:35
Message-ID: 20030818161735.GA24956@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Aug 18, 2003 at 17:56:00 +0200,
Bjørn T Johansen <btj(at)havleik(dot)no> wrote:
> I am already using Time for time fields (i.e. timestamp fields without
> the date part) in my database, are you saying this doesn't work???

No. You can't use HHMM format for input without doing some more work.
You can use HH:MM as an input format.

If you already have the data loaded into time fields, you can just
subtract them to get an interval.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Hervé Piedvache 2003-08-18 16:59:44 Re: Why lower's not accept an AS declaration ?
Previous Message btober 2003-08-18 16:01:41 Re: Simulating sequences