Extract(day,month ... From ?date)
And then some ifs and etc

Regards, Bogdan

Lp, Bogdan

Sent from Win 7.5 mobile

-----Original Message-----
From: SoftTech
Sent: 26.1.2012 12:50
To: firebird-support@yahoogroups.com
Subject: [firebird-support] How do I convert a timestamp to a string from within a stored procedure?

Greetings All,

Does anyone know how I can accomplish this from within a stored procedure?

I need to convert a timestamp 01/26/2012 05:38:32am to a string
01262012053832.

Will actually be using CURRENT_TIMESTAMP within the stored procedure.

Still using Firebird 1.5.3 (Hope to convert down the road)

Thanks to all who respond.

Mike



[The entire original message is not included.]

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