| From: | Luiz Eduardo Cantanhede Neri <lecneri(at)gmail(dot)com> | 
|---|---|
| To: | postgresql novice <pgsql-novice(at)postgresql(dot)org> | 
| Subject: | extract and interval | 
| Date: | 2009-05-25 13:15:42 | 
| Message-ID: | 252e1f290905250615h7569127bqc4f46fcb3be29906@mail.gmail.com | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-novice | 
Is there an good way to extract the interval unit that were used?
E.g. I used interval '2h' and another case I used '3d', theses are
respectively  2 hours and 3 days, but the format that came on select is
'02:00:00' for hour and '3 days' for days
What I'm looking for is something like 2h and 3d just as inserted.
The only solution so far I could came up with is call to_char function using
the unit of time and get the highest position for each couple of digits.
Ex: to_char(interval, 'DDHH24')
let's suppose the result is 0003 then I know it's 3 hours if I get 0100 I
know it's 1 day.
Open to suggestions :)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oliveiros Cristina | 2009-05-25 13:32:14 | Obtaining a limited number of records from a long query | 
| Previous Message | Luiz Eduardo Cantanhede Neri | 2009-05-25 10:44:36 | Tool for modeling |