dbTalk Databases Forums  

What i wrong with this stored procedure?

comp.databases.btrieve comp.databases.btrieve


Discuss What i wrong with this stored procedure? in the comp.databases.btrieve forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
yatuchabe@hotmail.com
 
Posts: n/a

Default What i wrong with this stored procedure? - 01-02-2005 , 11:20 PM






CREATE PROCEDURE ConvertDate();
BEGIN
DECLARE :a integer;
set :a = 74513;
SELECT TIMESTAMPADD( SQL_TSI_DAY, :a, CONVERT('1800-12-28 00:00:00',
SQL_TIMESTAMP));
END

I'm trying to convert a clarion serial date(which is a serial number
based on Dec 28, 1800). This serial date is in a Integer column. Right
now I'm just trying to get the procedure to work with hardcoded data.
The number 74513 is Nov 17, 2003. When I execute the query : CALL
Convertdate() I get the error "Invalid Argument". What am I doing
wrong?

TIA
Carlos San Miguel


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.