Index: openacs-4/packages/acs-core-docs/www/variables.adp =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-core-docs/www/variables.adp,v diff -u -r1.1.2.4 -r1.1.2.5 --- openacs-4/packages/acs-core-docs/www/variables.adp 4 Oct 2015 13:36:55 -0000 1.1.2.4 +++ openacs-4/packages/acs-core-docs/www/variables.adp 1 Dec 2015 11:17:58 -0000 1.1.2.5 @@ -19,7 +19,7 @@ OpenACS documentation staff.

Starting with OpenACS 5.0 and the introduction of acs-lang, we recommend retrieving date/time information from the database in ANSI format and then using lc_time_fmt to format it for display.

-

Example 12.1. Getting +

Example 12.1. Getting datetime from the database ANSI-style

 db_multirow -extend { mydate_pretty } {
     select to_char(mydate, 'YYYY-MM-DD HH24:MI:SS') as mydate_ansi,