Re: Entering time into postgresql

From: David Wilson <david(dot)t(dot)wilson(at)gmail(dot)com>
To: BlackMage <dsd7872(at)uncw(dot)edu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Entering time into postgresql
Date: 2009-06-08 16:23:30
Message-ID: e7f9235d0906080923v2ab785fdqa0079be62080a5b5@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Jun 8, 2009 at 11:04 AM, BlackMage <dsd7872(at)uncw(dot)edu> wrote:

> Is there a field that can actually store time in PostgreSql. And what I mean
> by time is not like time of the day, but a specific amount of time.

The manual is your friend:
http://www.postgresql.org/docs/8.3/static/datatype-datetime.html

The interval data type is what you're looking for.

--
- David T. Wilson
david(dot)t(dot)wilson(at)gmail(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Vick Khera 2009-06-08 16:23:38 Re: Entering time into postgresql
Previous Message Steve Crawford 2009-06-08 16:11:26 Re: How to store text files in the postgresql?