Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
> Nevertheless, I think there's something interesting missing here, which
> is a sort of strftime's %c format string.
Perhaps, but let us please not cram random non-Oracle-compatible stuff
into to_date/to_char. Those have a charter already.
regards, tom lane