Re: Date/Time manipulation

Article View: borland.public.interbase.sql

Article #975

Back to borland.public.interbase.sql Previous Next

#975

From: Assen Krastev
Date: Tue, 03 Apr 2007 11:37

32 lines
1679 bytes

Hmm, well, you are right. Wrong example I guess... I'm trying to
increase/decrease/encode datetime values. For example add +1 to TimeStamp to
go to the next day.

"Bill Todd" <no@no.com> wrote in message
news:460d3ff5$1@newsgroups.borland.com...

> 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: <46123adf@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!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> <460d3ff5$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: "Assen Krastev" <assen@transimpex.bg>
Newsgroups: borland.public.interbase.sql
References:  <460cf6d2$1@newsgroups.borland.com> <460d3ff5$1@newsgroups.borland.com>
Subject: Re: Date/Time manipulation
Date: Tue, 3 Apr 2007 14:37:20 +0300
Lines: 34
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1807
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1896
NNTP-Posting-Host: 212.50.10.82
Message-ID: <46123adf@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1175599839 212.50.10.82 (3 Apr 2007 04:30:39 -0800)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message