Subject | How do I convert CURRENT_TIME and CURRENT_DATE to a string? |
---|---|
Author | SoftTech |
Post date | 2008-11-15T14:52:33Z |
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]
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]