Home
Top.Mail.Ru Yandeks.Metrika
Forum: "Bases";
Current archive: 2002.01.08;
Download: [xml.tar.bz2];

Down

Good people help with the stored procedure. Find similar branches


Rev   (2001-12-03 12:19) [0]

Is it possible to write a stored procedure,
which will return YEAR (2001)
(YEAR type CHAR (4) or INTEGER)
with the input parameter (ADate DATE).
Urgent need.



Romkin   (2001-12-03 12:48) [1]

http://ib.demo.ru/DevInfo/Datetime.txt
Strange, the previous answer evaporated ..



Женька   (2001-12-03 12:49) [2]

CREATE PROCEDURE YearFromDate ( aDate DATE) RETURNS ( nYear INTEGER) As BEGIN FOR select EXTRACT (year from: aDate) from rdb $ database INTO: nYear DO BEGIN SUSPEND End End



Alexandr   (2001-12-04 08:45) [3]

2 Zhenya:
Is that a joke?
CREATE PROCEDURE YearFromDate (
aDate DATE)
RETURNS (
nYear INTEGER)
AS
BEGIN
select EXTRACT (year from: aDate) from rdb $ database INTO: nYear
Suspend;
END

it's easier.
By the way, this is only for IB6 and Firebird



yuger   (2001-12-05 12:09) [4]

Um .. Strange.
My dogger under Firebird doesn’t have this syntax.
Writes:
Token Unknown - line 7, char 21
from



Pages: 1 whole branch

Forum: "Bases";
Current archive: 2002.01.08;
Download: [xml.tar.bz2];

Top





Memory: 0.55 MB
Time: 0.022 c
3-21984
Mr. Andrew
2001-12-05 20:39
2002.01.08
Data update


14-22329
Dima-k17
2001-11-03 15:12
2002.01.08
Delphi times are over?


4-22506
gluka
2001-11-06 00:16
2002.01.08
How to cram a * .dll file in an exe file?


1-22069
Xtorm
2001-12-19 10:40
2002.01.08
How?


1-22210
Man in red
2001-12-15 20:12
2002.01.08
How namut such that ............................





afrikaans albanian Arabic armenian azerbaijani basque belarusian bulgarian catalan Chinese (Simplified) Chinese (Traditional) croatian Czech danish Dutch English estonian filipino finnish French
galician georgian German greek haitian Creole hebrew Hindi hungarian icelandic indonesian Irish italian Japanese Korean latvian lithuanian macedonian malay maltese norwegian
persian polish portuguese Romanian russian serbian slovak Slovenian Spanish swahili Swedish thai turkish Ukrainian urdu vietnamese welsh yiddish bengali bosnian
cebuano Esperanto gujarati hausa hmong igbo javanese kannada Khmer lao latin maori marathi mongolian nepali punjabi somali tamil telugu yoruba
zulu
English French German Italian Portuguese Russian Spanish