From smith.not.western@gmail.com Mon Sep 11 04:53:45 2006 X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 01A1A9FA3B1 for ; Mon, 11 Sep 2006 01:53:45 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 24731-07 for ; Mon, 11 Sep 2006 04:53:37 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.176]) by postgresql.org (Postfix) with ESMTP id AA8B09F9F80 for ; Mon, 11 Sep 2006 01:53:37 -0300 (ADT) Received: by py-out-1112.google.com with SMTP id d80so1993882pyd for ; Sun, 10 Sep 2006 21:53:36 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type; b=mvqiwYuP+01T6fiP7NxGejdAEGntUVTKV224qMdrFesDWLx+EBxWaquAvY8+tn0vSRbqVmnJoXrYQEMWDALmm5k9q0RKe1KKmhrg9CpVzcW+wCaNdX/X2hctKbpWEGQjFnVykq5jrFdVKoYcbYJ5TsypCgUd7F4t/FEgFpgFHLs= Received: by 10.65.153.10 with SMTP id f10mr1362574qbo; Sun, 10 Sep 2006 21:53:36 -0700 (PDT) Received: by 10.65.54.11 with HTTP; Sun, 10 Sep 2006 21:53:36 -0700 (PDT) Message-ID: Date: Mon, 11 Sep 2006 16:53:36 +1200 From: "Mike C" To: pgsql-admin@postgresql.org Subject: SELECT and DATE Function question MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_156645_6512629.1157950416635" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.551 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, HTML_10_20, HTML_MESSAGE, SPF_PASS X-Spam-Level: * X-Archive-Number: 200609/77 X-Sequence-Number: 22991 ------=_Part_156645_6512629.1157950416635 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi, I'm trying to calculate an expiration date by adding the number of days onto the start date. i.e. select start_date + number_of_days from blah; create table blah (start_date timestamp, number_of_days integer); insert into blah values (current_timestamp, 25); select start_date + number_of_days from blah; The error I get is: ERROR: operator does not exist: timestamp without time zone + integer HINT: No operator matches the given name and argument type(s). You may need to add explicit type casts. But according to http://www.postgresql.org/docs/8.1/static/functions-datetime.html the + operator should support integers and treat them as days (date '2001-09-28' + integer '7'). Obviously typing a constant into the query is a lot different from using the value of a column, but I would have thought it would work. What is the correct way to make this calculation? Cheers, Mike ------=_Part_156645_6512629.1157950416635 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi,

I'm trying to calculate an expiration date by adding the number of days onto the start date. i.e. select start_date + number_of_days from blah;

create table blah (start_date timestamp, number_of_days integer);
insert into blah values (current_timestamp, 25);
select start_date + number_of_days from blah;

The error I get is:

ERROR:  operator does not exist: timestamp without time zone + integer
HINT:  No operator matches the given name and argument type(s). You may need to add explicit type casts.

But according to http://www.postgresql.org/docs/8.1/static/functions-datetime.html the + operator should support integers and treat them as days ( date '2001-09-28' + integer '7'). Obviously typing a constant into the query is a lot different from using the value of a column, but I would have thought it would work.

What is the correct way to make this calculation?

Cheers,

Mike
------=_Part_156645_6512629.1157950416635-- From postgresql@aranya.com Mon Sep 11 05:43:11 2006 X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id D28C79FB3AE for ; Mon, 11 Sep 2006 02:43:11 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 29492-05-2 for ; Mon, 11 Sep 2006 02:42:56 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.182]) by postgresql.org (Postfix) with ESMTP id 81BB39FB3B9 for ; Mon, 11 Sep 2006 02:27:47 -0300 (ADT) Received: by py-out-1112.google.com with SMTP id d80so2006449pyd for ; Sun, 10 Sep 2006 22:27:46 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:sender:to:subject:cc:in-reply-to:mime-version:content-type:references:x-google-sender-auth; b=iXT1xlwRLyK9e53vt40kRltOIfqANrinqnj96BTZTMymucukdXQdt8v0MsD8M4dGYOMVAdqavByjAM6LaFfSGb9wZwX/IPgdbHIcafryTajjZPjv7jfrp9Hz8whbqtsPc1sfPckRcVfcoM7sqC8trbUTLJWPN/uuNsMQrXnKlgo= Received: by 10.35.78.13 with SMTP id f13mr8770480pyl; Sun, 10 Sep 2006 22:27:46 -0700 (PDT) Received: by 10.35.80.9 with HTTP; Sun, 10 Sep 2006 22:27:46 -0700 (PDT) Message-ID: Date: Mon, 11 Sep 2006 00:27:46 -0500 From: "Aaron Bono" To: "Mike C" Subject: Re: SELECT and DATE Function question Cc: pgsql-admin@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_66501_15097589.1157952466264" References: X-Google-Sender-Auth: 0615f705b4b94285 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.636 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, HTML_30_40, HTML_MESSAGE, SPF_PASS X-Spam-Level: X-Archive-Number: 200609/78 X-Sequence-Number: 22992 ------=_Part_66501_15097589.1157952466264 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline On 9/10/06, Mike C wrote: > > Hi, > > I'm trying to calculate an expiration date by adding the number of days > onto the start date. i.e. select start_date + number_of_days from blah; > > create table blah (start_date timestamp, number_of_days integer); > insert into blah values (current_timestamp, 25); > select start_date + number_of_days from blah; > > The error I get is: > > ERROR: operator does not exist: timestamp without time zone + integer > HINT: No operator matches the given name and argument type(s). You may > need to add explicit type casts. > > But according to > http://www.postgresql.org/docs/8.1/static/functions-datetime.html the + > operator should support integers and treat them as days ( date > '2001-09-28' + integer '7'). Obviously typing a constant into the query is a > lot different from using the value of a column, but I would have thought it > would work. > > What is the correct way to make this calculation? > Use: select start_date + (cast(number_of_days as text) || ' days')::interval from blah See http://www.postgresql.org/docs/8.1/interactive/functions-datetime.htmlfor more ================================================================== Aaron Bono Aranya Software Technologies, Inc. http://www.aranya.com http://codeelixir.com ================================================================== ------=_Part_66501_15097589.1157952466264 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline On 9/10/06, Mike C <smith.not.western@gmail.com> wrote:
Hi,

I'm trying to calculate an expiration date by adding the number of days onto the start date. i.e. select start_date + number_of_days from blah;

create table blah (start_date timestamp, number_of_days integer);
insert into blah values (current_timestamp, 25);
select start_date + number_of_days from blah;

The error I get is:

ERROR:  operator does not exist: timestamp without time zone + integer
HINT:  No operator matches the given name and argument type(s). You may need to add explicit type casts.

But according to http://www.postgresql.org/docs/8.1/static/functions-datetime.html the + operator should support integers and treat them as days ( date '2001-09-28' + integer '7'). Obviously typing a constant into the query is a lot different from using the value of a column, but I would have thought it would work.

What is the correct way to make this calculation?

 
Use:

select start_date + (cast(number_of_days as text) || ' days')::interval from blah

See http://www.postgresql.org/docs/8.1/interactive/functions-datetime.html for more

==================================================================
   Aaron Bono
   Aranya Software Technologies, Inc.
   http://www.aranya.com
   http://codeelixir.com
================================================================== ------=_Part_66501_15097589.1157952466264-- From smith.not.western@gmail.com Mon Sep 11 05:43:23 2006 X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 68EC69FB3B9 for ; Mon, 11 Sep 2006 02:43:23 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 35867-03-5 for ; Mon, 11 Sep 2006 05:43:15 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.177]) by postgresql.org (Postfix) with ESMTP id 6A6879FB3D2 for ; Mon, 11 Sep 2006 02:34:04 -0300 (ADT) Received: by py-out-1112.google.com with SMTP id d80so2008897pyd for ; Sun, 10 Sep 2006 22:34:03 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; b=a4gBR5VlY8hFIqt6PhrKSWZox0/yLOY8qu0ef19Nqpuv1468cxBTJTT3pwmbmaciKsHvBqiMqhlegKBaNGBSiVfPW/Lv10YyTSeVd4lk4ZJkKktDPMekzUA2lnTKDd9qndjBgD4WeGfepZvx/7+HtKAkkna6CHbFaw7zVHGS19o= Received: by 10.65.43.5 with SMTP id v5mr1206299qbj; Sun, 10 Sep 2006 22:34:03 -0700 (PDT) Received: by 10.65.54.11 with HTTP; Sun, 10 Sep 2006 22:34:03 -0700 (PDT) Message-ID: Date: Mon, 11 Sep 2006 17:34:03 +1200 From: "Mike C" To: pgsql-admin@postgresql.org Subject: Re: SELECT and DATE Function question In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_156801_10391035.1157952843330" References: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.334 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, HTML_50_60, HTML_MESSAGE, SPF_PASS X-Spam-Level: X-Archive-Number: 200609/79 X-Sequence-Number: 22993 ------=_Part_156801_10391035.1157952843330 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline That works great, thank you! Mike On 9/11/06, Aaron Bono wrote: > > On 9/10/06, Mike C wrote: > > > Hi, > > > > I'm trying to calculate an expiration date by adding the number of days > > onto the start date. i.e. select start_date + number_of_days from blah; > > > > create table blah (start_date timestamp, number_of_days integer); > > insert into blah values (current_timestamp, 25); > > select start_date + number_of_days from blah; > > > > The error I get is: > > > > ERROR: operator does not exist: timestamp without time zone + integer > > HINT: No operator matches the given name and argument type(s). You may > > need to add explicit type casts. > > > > But according to http://www.postgresql.org/docs/8.1/static/functions-datetime.html > > the + operator should support integers and treat them as days ( date > > '2001-09-28' + integer '7'). Obviously typing a constant into the query is a > > lot different from using the value of a column, but I would have thought it > > would work. > > > > What is the correct way to make this calculation? > > > > > Use: > > select start_date + (cast(number_of_days as text) || ' days')::interval > from blah > > See http://www.postgresql.org/docs/8.1/interactive/functions-datetime.htmlfor more > > ================================================================== > Aaron Bono > Aranya Software Technologies, Inc. > http://www.aranya.com > http://codeelixir.com > ================================================================== > ------=_Part_156801_10391035.1157952843330 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline That works great, thank you!

Mike

On 9/11/06, Aaron Bono <postgresql@aranya.com> wrote:
On 9/10/06, Mike C <smith.not.western@gmail.com > wrote:
Hi,

I'm trying to calculate an expiration date by adding the number of days onto the start date. i.e. select start_date + number_of_days from blah;

create table blah (start_date timestamp, number_of_days integer);
insert into blah values (current_timestamp, 25);
select start_date + number_of_days from blah;

The error I get is:

ERROR:  operator does not exist: timestamp without time zone + integer
HINT:  No operator matches the given name and argument type(s). You may need to add explicit type casts.

But according to http://www.postgresql.org/docs/8.1/static/functions-datetime.html the + operator should support integers and treat them as days ( date '2001-09-28' + integer '7'). Obviously typing a constant into the query is a lot different from using the value of a column, but I would have thought it would work.

What is the correct way to make this calculation?

 
Use:

select start_date + (cast(number_of_days as text) || ' days')::interval from blah

See http://www.postgresql.org/docs/8.1/interactive/functions-datetime.html for more

==================================================================
   Aaron Bono
   Aranya Software Technologies, Inc.
   http://www.aranya.com
   http://codeelixir.com
==================================================================

------=_Part_156801_10391035.1157952843330-- From topaz@panix.com Mon Sep 11 08:00:17 2006 X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id DE2669FA7BA for ; Mon, 11 Sep 2006 05:00:17 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 40009-07 for ; Mon, 11 Sep 2006 05:00:05 -0300 (ADT) X-Greylist: delayed 00:30:10.310185 by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id C13719FB1C8 for ; Mon, 11 Sep 2006 05:00:02 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from mail1.panix.com (mail1.panix.com [166.84.1.72]) by svr4.postgresql.org (Postfix) with ESMTP id 5DEFE5AF03D for ; Mon, 11 Sep 2006 07:29:51 +0000 (GMT) Received: from mailspool3.panix.com (mailspool3.panix.com [166.84.1.78]) by mail1.panix.com (Postfix) with ESMTP id 9876758896; Mon, 11 Sep 2006 03:29:49 -0400 (EDT) Received: from [192.168.0.1] (j074054.ppp.asahi-net.or.jp [61.213.74.54]) by mailspool3.panix.com (Postfix) with ESMTP id 06A2BD908E1; Mon, 11 Sep 2006 03:29:48 -0400 (EDT) Subject: Re: SELECT and DATE Function question From: Jason Topaz To: Mike C Cc: pgsql-admin@postgresql.org In-Reply-To: References: Content-Type: text/plain Date: Mon, 11 Sep 2006 16:29:32 +0900 Message-Id: <1157959773.2338.5.camel@trane.shiawase.org> Mime-Version: 1.0 X-Mailer: Evolution 2.6.3 (2.6.3-1.fc5.5) Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.069 tagged_above=0 required=5 tests=SPF_NEUTRAL X-Spam-Level: * X-Archive-Number: 200609/80 X-Sequence-Number: 22994 On Mon, 2006-09-11 at 16:53 +1200, Mike C wrote: > create table blah (start_date timestamp, number_of_days integer); > insert into blah values (current_timestamp, 25); > select start_date + number_of_days from blah; > > The error I get is: > > ERROR: operator does not exist: timestamp without time zone + integer > HINT: No operator matches the given name and argument type(s). You > may need to add explicit type casts. > > But according to > http://www.postgresql.org/docs/8.1/static/functions-datetime.html the > + operator should support integers and treat them as days ( date > '2001-09-28' + integer '7'). Obviously typing a constant into the > query is a lot different from using the value of a column, but I would > have thought it would work. That's because your data type was "timestamp", not "date". I don't believe the documentation claims the + operator works on a timestamp and an integer. But it does claim (correctly) that it works on a date and an integer. The following example does work: create table blah (start_date date, number_of_days integer); insert into blah values (current_date, 25); select start_date + number_of_days from blah; Hope that helps a little, at least to explain the apparent disconnect from the documentation. From tgl@sss.pgh.pa.us Mon Sep 11 14:08:39 2006 X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 65FEC9FA5EA for ; Mon, 11 Sep 2006 11:08:39 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 81375-01 for ; Mon, 11 Sep 2006 11:08:29 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 898509FB228 for ; Mon, 11 Sep 2006 11:08:29 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id k8BE8OjO022489; Mon, 11 Sep 2006 10:08:24 -0400 (EDT) To: "Aaron Bono" cc: "Mike C" , pgsql-admin@postgresql.org Subject: Re: SELECT and DATE Function question In-reply-to: References: Comments: In-reply-to "Aaron Bono" message dated "Mon, 11 Sep 2006 00:27:46 -0500" Date: Mon, 11 Sep 2006 10:08:24 -0400 Message-ID: <22488.1157983704@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.11 tagged_above=0 required=5 tests=AWL, SPF_HELO_PASS, SPF_PASS X-Spam-Level: X-Archive-Number: 200609/90 X-Sequence-Number: 23004 "Aaron Bono" writes: > Use: > select start_date + (cast(number_of_days as text) || ' days')::interval from > blah This is a pretty awful way to do it, much better is select start_date + number_of_days * '1 day'::interval ... which reduces to basically one multiplication instead of conversion to text, text string append, parse interval string value (relying on a couple of undocumented cast abilities). But the real question here is whether you actually want sub-day precision in your result. Should the column have been 'date' rather than 'timestamp' to begin with? If not, what behavior are you expecting at DST boundaries? regards, tom lane From postgresql@aranya.com Mon Sep 11 15:03:53 2006 X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 9F97E9FB228 for ; Mon, 11 Sep 2006 12:03:53 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 82165-09 for ; Mon, 11 Sep 2006 12:03:35 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.182]) by postgresql.org (Postfix) with ESMTP id 3D0199FA5EA for ; Mon, 11 Sep 2006 12:03:35 -0300 (ADT) Received: by py-out-1112.google.com with SMTP id d80so2219143pyd for ; Mon, 11 Sep 2006 08:03:34 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:sender:to:subject:cc:in-reply-to:mime-version:content-type:references:x-google-sender-auth; b=TF801OXExG1QOjgvfbaznRQLSyk8FSMoValeYLZxA0k95FLK1ogT97annMvXVwEvMrNSpKmXkBSkcdFydEd+TV4NBv/a5zsH3xcIj6UWJLKtVW3mjM79pl4Skpu6aTaqXFYCNM+tNTwlOG0LKOo79b4IZN0X8yZP2eqz2Vslcrs= Received: by 10.35.53.18 with SMTP id f18mr9025063pyk; Mon, 11 Sep 2006 08:03:34 -0700 (PDT) Received: by 10.35.80.9 with HTTP; Mon, 11 Sep 2006 08:03:34 -0700 (PDT) Message-ID: Date: Mon, 11 Sep 2006 10:03:34 -0500 From: "Aaron Bono" To: "Tom Lane" Subject: Re: SELECT and DATE Function question Cc: "Mike C" , pgsql-admin@postgresql.org In-Reply-To: <22488.1157983704@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_73260_4182059.1157987014109" References: <22488.1157983704@sss.pgh.pa.us> X-Google-Sender-Auth: cd9274a52f6a15a7 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.527 tagged_above=0 required=5 tests=AWL, HTML_30_40, HTML_MESSAGE, SPF_PASS X-Spam-Level: X-Archive-Number: 200609/92 X-Sequence-Number: 23006 ------=_Part_73260_4182059.1157987014109 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline On 9/11/06, Tom Lane wrote: > > "Aaron Bono" writes: > > Use: > > > select start_date + (cast(number_of_days as text) || ' days')::interval > from > > blah > > This is a pretty awful way to do it, much better is > > select start_date + number_of_days * '1 day'::interval ... > > which reduces to basically one multiplication instead of conversion to > text, text string append, parse interval string value (relying on a > couple of undocumented cast abilities). I knew there was a better way but I forgot what it was and couldn't find it in the documentation. Could the documentation be updated with this example? This question appears every month or so and I know it is very useful to many people. Thanks! ================================================================== Aaron Bono Aranya Software Technologies, Inc. http://www.aranya.com http://codeelixir.com ================================================================== ------=_Part_73260_4182059.1157987014109 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline On 9/11/06, Tom Lane <tgl@sss.pgh.pa.us> wrote:
"Aaron Bono" <postgresql@aranya.com> writes:
> Use:

> select start_date + (cast(number_of_days as text) || ' days')::interval from
> blah

This is a pretty awful way to do it, much better is

        select start_date + number_of_days * '1 day'::interval ...

which reduces to basically one multiplication instead of conversion to
text, text string append, parse interval string value (relying on a
couple of undocumented cast abilities).

 
I knew there was a better way but I forgot what it was and couldn't find it in the documentation.

Could the documentation be updated with this example?  This question appears every month or so and I know it is very useful to many people.

Thanks!

==================================================================
   Aaron Bono
   Aranya Software Technologies, Inc.
   http://www.aranya.com
   http://codeelixir.com
================================================================== ------=_Part_73260_4182059.1157987014109--