dates difference

Article View: borland.public.interbase.sql

Article #974

Back to borland.public.interbase.sql Previous Next

#974

From: aleplgr
Date: Tue, 03 Apr 2007 11:39

7 lines
1080 bytes

Hi! I'm trying to calculate a dates difference  in a stored procedure in InterBase 7.5:  given two dates in dd/mm/yyyy format I need its difference in days,
like this one in SQL 2000:
 
 set @Days = (SELECT DATEDIFF(DAY,@val1, @val2))

 is there a predefined function to do that? couldn't find it in the Language Reference nor Data Reference..

Technical Details

Message-ID: <46122eec$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,2c9d003309cca840,start
X-Google-Attributes: gid114a0e,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "aleplgr" <aleplgr@yahoo.es>
Sender: "aleplgr" <aleplgr@yahoo.es>
Reply-To: "aleplgr" <aleplgr@yahoo.es>
Subject: dates difference
Newsgroups: borland.public.interbase.sql
X-User-Info: 80.58.205.38     
X-Forwarded-For: 80.25.195.180, 192.168.1.55
NNTP-Posting-Host: 207.105.83.66
Message-ID: <46122eec$1@newsgroups.borland.com>
Date: 3 Apr 2007 03:39:40 -0800
X-Trace: newsgroups.borland.com 1175596780 207.105.83.66 (3 Apr 2007 03:39:40 -0800)
Lines: 8
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail