Thread: strftime

I'm wondering how hard will it be to implement POSIX strftime function and
what's the best way to go about it? I hooked up similar functions to MySQL
in the past and all it took was little modification to example C code,
compiling it as a shared library and issuing one SQL statement. What's the
PostgreSQL's way to do it?

Best regards,
Egor Shipovalov.

Egor Shipovalov wrote:

> I'm wondering how hard will it be to implement POSIX strftime function and
> what's the best way to go about it? I hooked up similar functions to MySQL
> in the past and all it took was little modification to example C code,
> compiling it as a shared library and issuing one SQL statement. What's the
> PostgreSQL's way to do it?

You can write wrappers for any C function:

http://www.postgresql.org/docs/7.3/static/xfunc-c.html

But PostgreSQL may be able to already to what you want using TO_CHAR():

http://www.postgresql.org/docs/7.3/static/functions-formatting.html

Hope that helps,

Mike Mascari
mascarm@mascari.com