Re: [GENERAL] Entering time into postgresql
On Mon, Jun 8, 2009 at 11:04 AM, BlackMage 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. This is known as type "INTERVAL" to postgres. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Entering time into postgresql
On Mon, Jun 8, 2009 at 11:04 AM, BlackMage 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.t.wil...@gmail.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] Entering time into postgresql
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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general