Skip site navigation (1) Skip section navigation (2)

Time Help

From: "Brian C(dot) Doyle" <bcdoyle(at)mindspring(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Time Help
Date: 2000-08-22 10:47:19
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-sql
Hello all,

I have a query result of @ 2 hours 10 mins 6 secs and I would like to 
change that to 02:10:06.  Currently the field is listed as "timespan"  This 
allows me to input date as 02:10:06 or 4h 10m 6s or even 2hrs 10 min 6 sec 
which are all the formats that I will be entering the time formats! How do 
I convert it into a the format of 02:10:06

Thanks to you all


pgsql-sql by date

Next:From: Keith WongDate: 2000-08-22 11:16:23
Subject: tip: weird parse error for pl/pgsql
Previous:From: Alex GuryanowDate: 2000-08-22 10:03:42
Subject: using INTERSECT and UNION in IN clause

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group