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, year, hour, etc. and use
|| operator to concatenate numbers into string. To make sure numbers are
zero padded you can use STR_PAD or CASE like this:

case when number < 10 then '0'||number else number end

I mention CASE because STR_PAD is not available in older versions of FB.

Alternatively there are UDF libraries (rfunc for example) that provide
date format functions. So you could write something like:

DateToStr(current_timestamp, '%d%m%Y%h%M%S')

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

In that case, use DateToStr or CASE.

--
Milan Babuskov

==================================
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==================================