Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
[GENERAL] Converting/formatting timestamp arithmetic
0 views
Skip to first unread message
Karel Zak
Mar 14, 2002, 4:21:59 AM3/14/02
to
On Thu, Mar 07, 2002 at 05:42:00PM -0800, Eel wrote:
> Hi,
> Is there any easy way to convert the result of timestamp
> arithmetic to a simple decimal number?
>
> I have something like:
>
> select current_timestamp - timein as daysat from transcations
>
> daysat looks like:
>
> 3 days 12:00:00
>
> I want it to look like:
>
> 3.5
> Hi,
> Is there any easy way to convert the result of timestamp
> arithmetic to a simple decimal number?
>
> I have something like:
>
> select current_timestamp - timein as daysat from transcations
>
> daysat looks like:
>
> 3 days 12:00:00
>
> I want it to look like:
>
> 3.5
test=# select date_part('d', '3 days 12:00:00'::interval) + (1 / (24 /
date_part('h', '3 days 12:00:00'::interval)));
?column?
----------
3.5
test=# select date_part('d', '3 days 6:00:00'::interval) + (1 / (24 /
date_part('h', '3 days 6:00:00'::interval)));
?column?
----------
3.25
> I fooled around a bit to_number(text, text). It seems like
IMHO better is extract relavant values and count it.
Karel
--
Karel Zak <za...@zf.jcu.cz>
http://home.zf.jcu.cz/~zakkr/
C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
0 new messages