Re: Date/Time manipulation

Article View: borland.public.interbase.sql

Article #964

Back to borland.public.interbase.sql Previous Next

#964

From: Bill Todd
Date: Fri, 30 Mar 2007 17:51

25 lines
1411 bytes

Assen Krastev wrote:

> In a stored proc:
> ...
> returns (t timestamp)
> as
> declare variable time1 as timestamp;
> declare variable time2 as timestamp;
> declare variable d as double precision;
> begin
>   ...
>   d=time2-time1;
>   t=cast(d as timestamp);<---- error
>   suspend;
> end
> 
> How can I cast 'd' back to TimeStamp?
> 
> Thanks.

The variable d contains an interval, not a timestamp. What are you
trying to accomplish.

-- 
Bill Todd (TeamB)

Technical Details

Message-ID: <460d3ff5$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!proxad.net!213.200.89.82.MISMATCH!tiscali!newsfeed1.ip.tiscali.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <460cf6d2$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,e403051073053b92
X-Google-Attributes: gid114a0e,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Bill Todd" <no@no.com>
Subject: Re: Date/Time manipulation
Newsgroups: borland.public.interbase.sql
References:  <460cf6d2$1@newsgroups.borland.com>
Organization: The Database Group, Inc.
User-Agent: XanaNews/1.18.1.6
X-Face: ":yn4zt^A_dn>6~{YJmu^B\'4w)e:apPM\VC=Dvf&*tASxX9|BYczkFd$xr.$vNSZ[3Uobr p]c4\+\l){!WQI.$]veP({HLd;CDYH?iN
NNTP-Posting-Host: 216.207.211.19
Message-ID: <460d3ff5$1@newsgroups.borland.com>
Date: 30 Mar 2007 09:51:01 -0800
X-Trace: newsgroups.borland.com 1175273461 216.207.211.19 (30 Mar 2007 09:51:01 -0800)
Lines: 25
X-Authenticated-User: btodd
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!proxad.net!213.200.89.82.MISMATCH!tiscali!newsfeed1.ip.tiscali.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message