Entering time into postgresql

From: BlackMage <dsd7872(at)uncw(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: Entering time into postgresql
Date: 2009-06-08 15:04:37
Message-ID: 23925803.post@talk.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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 application I am developing records how long it takes for a user to do a
task, say 5 minutes and 32 seconds. That time is entered into the database
so latter it can be sorta like: "SELECT * FROM user_time WHERE
time_taken<6:00".

Thanks in advance.
--
View this message in context: http://www.nabble.com/Entering-time-into-postgresql-tp23925803p23925803.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ioana Danes 2009-06-08 15:41:35 Duplicate key issue in a transaction block
Previous Message Tom Lane 2009-06-08 13:50:53 Re: Foreign Key Unique Constraint can be dropped