Subject How do I convert CURRENT_TIME and CURRENT_DATE to a string?
Author SoftTech
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]