Re: [GENERAL] Entering time into postgresql

2009-06-08 Thread Vick Khera
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-gen

Re: [GENERAL] Entering time into postgresql

2009-06-08 Thread David Wilson
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

[GENERAL] Entering time into postgresql

2009-06-08 Thread BlackMage
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