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.4.2.10 -r1.4.2.11 --- openacs-4/packages/acs-core-docs/www/variables.adp 1 Aug 2024 08:03:42 -0000 1.4.2.10 +++ openacs-4/packages/acs-core-docs/www/variables.adp 2 Sep 2024 09:40:24 -0000 1.4.2.11 @@ -2,10 +2,14 @@ {/doc/acs-core-docs/ {ACS Core Documentation}} {Variables} Variables +

@@ -19,9 +23,8 @@ 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 datetime from -the database ANSI-style

-db_multirow -extend { mydate_pretty } {
+

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,
           ...
     ...