Index: openacs-4/packages/acs-core-docs/www/variables.html =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-core-docs/www/variables.html,v diff -u -r1.23.4.3 -r1.23.4.4 --- openacs-4/packages/acs-core-docs/www/variables.html 31 May 2008 20:46:16 -0000 1.23.4.3 +++ openacs-4/packages/acs-core-docs/www/variables.html 4 Oct 2008 23:12:43 -0000 1.23.4.4 @@ -1,10 +1,10 @@ -Variables
Alex logo
Prev Chapter�11.�Engineering Standards Next

Variables

Date and Time Variables

($Id$)

By joel@aufrecht.org

+Variables
Alex logo
Prev Chapter�12.�Engineering Standards Next

Variables

Date and Time Variables

($Id$)

By joel@aufrecht.org

OpenACS docs are written by the named authors, and may be edited by 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�11.1.�Getting datetime from the database ANSI-style

db_multirow -extend { mydate_pretty } {
+    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 } {
     select to_char(mydate, 'YYYY-MM-DD HH24:MI:SS') as mydate_ansi,
           ...
     ...