By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,512 Members | 668 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,512 IT Pros & Developers. It's quick & easy.

strftime

P: n/a
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.
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 11 '05 #1
Share this Question
Share on Google+
1 Reply

P: n/a
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/s...ormatting.html

Hope that helps,

Mike Mascari
ma*****@mascari.com

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 11 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.