Forum OpenACS Development: Recommended format from database for dt_format input?
unable to convert date-time string "2003-09-06 23:13:42.686629+02"
Is there a required configuration setting for postgres that I missed, which sets the output date format (analogous to NLS_DATE_FORMAT for oracle), or should we explicitely format the dates before passing them to dt_format, e.g. querying them like this:
to_char(some_date, 'YYYY-MM-DD HH24:MI'); + timezone somehow
(This should be in the dt_format api doc I guess)