> This is what you get when you copy a proprietary, poorly > specified interface. > The to_char functions are supposed to be Oracle-compatible, > so we need to check what Oracle does. Whether that is useful > in practice is a bit secondary. > > I'm beginning to think, if you want formatting functions that > are more sane, stable, and standardized, export sprintf and > strftime to PostgreSQL.
Perhaps this is good time to think about (I'm being careful to say redesign) a review both regarding date/time formatting and locale handling for these functions in general. Regards, Gevik ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org