Couldn't you use CAST as STRING on these fields then concatenate substrings
of the parts in the order needed?



From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of SoftTech
Sent: Saturday, November 15, 2008 6:53 AM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] How do I convert CURRENT_TIME and CURRENT_DATE
to a string?



Firebird 1.5

Inside of a stored procedure I declared the following:
DECLARE VARIABLE tTime Time;
DECLARE VARIABLE dDate Date;

I then assigned them as follows:
tTime = CURRENT_TIME;
dDate = CURRENT_DATE;

Which returns these value:
8:42:48 AM
11/15/2008

I need to convert the time value to a string in the following format:
084248

and I need to convert the date value to a string in the following format:
20081115

Anyone with any idea how to accomplish this?

Thanks for all who reply.

Mike

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]