[firebird-support] How do I convert a timestamp to a string from within a stored procedure?

2012-01-26 Thread SoftTech
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

Re: {Disarmed} [firebird-support] How do I convert a timestamp to a string from within a stored procedure?

2012-01-26 Thread SoftTech
I think I have something figured out... - Original Message - From: SoftTech To: firebird-support@yahoogroups.com Sent: Thursday, January 26, 2012 5:50 AM Subject: {Disarmed} [firebird-support] How do I convert a timestamp to a string from within a stored procedure?

Re: [firebird-support] How do I convert a timestamp to a string from within a stored procedure?

2012-01-26 Thread Milan Babuskov
SoftTech wrote: 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. You could use EXTRACT() to extract day, month,

RE: [firebird-support] How do I convert a timestamp to a string from within a stored procedure?

2012-01-26 Thread Bogdan
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