 | |
format interval as days
comp.databases.postgresql comp.databases.postgresql
 |
| | Thread Tools | Display Modes |
#21
 
| |||
| |||
|
Re: format interval as days -
05-09-2008
, 04:45 AM
|
Patrick Scharrenberg <pittipatti (AT) web (DOT) de> wrote: I'd like to represent an interval like '1 day 1h 2m 12s' in days, in this case 25 I assume you mean "hours". Ohh, yes you're right :-) |
Quote:
|
Is there a more convenient way of returning the number of hours than with a contruct like the following? I don't think there is a better way. You could write an SQL function around it: |
At least I can copy'n'paste your function ;-)
Quote:
|
And what if the interval is longer than a month? How many day's has an "interval-month"? There is an instructive comment in include/utils/timestamp.h: #define DAYS_PER_MONTH 30 /* assumes exactly 30 days per month */ |
Thank you Laurenz!
Patrick
#22
| |||
| |||
|
|
Patrick Scharrenberg <pittipatti (AT) web (DOT) de> wrote: I'd like to represent an interval like '1 day 1h 2m 12s' in days, in this case 25 I assume you mean "hours". Ohh, yes you're right :-) |
Quote:
|
Is there a more convenient way of returning the number of hours than with a contruct like the following? I don't think there is a better way. You could write an SQL function around it: |
At least I can copy'n'paste your function ;-)
Quote:
|
And what if the interval is longer than a month? How many day's has an "interval-month"? There is an instructive comment in include/utils/timestamp.h: #define DAYS_PER_MONTH 30 /* assumes exactly 30 days per month */ |
Thank you Laurenz!
Patrick
#23
| |||
| |||
|
|
Patrick Scharrenberg <pittipatti (AT) web (DOT) de> wrote: I'd like to represent an interval like '1 day 1h 2m 12s' in days, in this case 25 I assume you mean "hours". Ohh, yes you're right :-) |
Quote:
|
Is there a more convenient way of returning the number of hours than with a contruct like the following? I don't think there is a better way. You could write an SQL function around it: |
At least I can copy'n'paste your function ;-)
Quote:
|
And what if the interval is longer than a month? How many day's has an "interval-month"? There is an instructive comment in include/utils/timestamp.h: #define DAYS_PER_MONTH 30 /* assumes exactly 30 days per month */ |
Thank you Laurenz!
Patrick
#24
| |||
| |||
|
|
Patrick Scharrenberg <pittipatti (AT) web (DOT) de> wrote: I'd like to represent an interval like '1 day 1h 2m 12s' in days, in this case 25 I assume you mean "hours". Ohh, yes you're right :-) |
Quote:
|
Is there a more convenient way of returning the number of hours than with a contruct like the following? I don't think there is a better way. You could write an SQL function around it: |
At least I can copy'n'paste your function ;-)
Quote:
|
And what if the interval is longer than a month? How many day's has an "interval-month"? There is an instructive comment in include/utils/timestamp.h: #define DAYS_PER_MONTH 30 /* assumes exactly 30 days per month */ |
Thank you Laurenz!
Patrick
#25
| |||
| |||
|
|
Patrick Scharrenberg <pittipatti (AT) web (DOT) de> wrote: I'd like to represent an interval like '1 day 1h 2m 12s' in days, in this case 25 I assume you mean "hours". Ohh, yes you're right :-) |
Quote:
|
Is there a more convenient way of returning the number of hours than with a contruct like the following? I don't think there is a better way. You could write an SQL function around it: |
At least I can copy'n'paste your function ;-)
Quote:
|
And what if the interval is longer than a month? How many day's has an "interval-month"? There is an instructive comment in include/utils/timestamp.h: #define DAYS_PER_MONTH 30 /* assumes exactly 30 days per month */ |
Thank you Laurenz!
Patrick
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.