Обсуждение: Can you set the date output format (to_char style) per session?
Hello list! I am working through some i18n/l10n issues in a new application and one of our possible solutions for handling date formattingis to have the dates formatted by pgsql per session. I know I Can use DateStyle to adjust date output, but I amlooking for something that works like SET DateStyle but with finer control like to_char(format, timestamp). Is there such thing? Thanks, Josh
hello 2010/3/4 Joshua Johnston <johnston.joshua@gmail.com>: > Hello list! > > I am working through some i18n/l10n issues in a new application and one of our possible solutions for handling date formattingis to have the dates formatted by pgsql per session. I know I Can use DateStyle to adjust date output, but I amlooking for something that works like SET DateStyle but with finer control like to_char(format, timestamp). > > Is there such thing? > no no on sql level - you can do some only in C lang - create own type - compatible with timestamp but with own output function. regards Pavel Stehule > Thanks, > > Josh > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
On Mar 4, 2010, at 2:51 PM, Pavel Stehule wrote: > hello > > 2010/3/4 Joshua Johnston <johnston.joshua@gmail.com>: >> Hello list! >> >> I am working through some i18n/l10n issues in a new application and one of our possible solutions for handling date formattingis to have the dates formatted by pgsql per session. I know I Can use DateStyle to adjust date output, but I amlooking for something that works like SET DateStyle but with finer control like to_char(format, timestamp). >> >> Is there such thing? >> > > no > > no on sql level - you can do some only in C lang - create own type - > compatible with timestamp but with own output function. > > regards > Pavel Stehule > That is what I thought. Thank you for your quick reply Pavel!