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 -N -r1.1.2.14 -r1.1.2.15 --- openacs-4/packages/acs-core-docs/www/variables.adp 30 Nov 2016 08:15:11 -0000 1.1.2.14 +++ openacs-4/packages/acs-core-docs/www/variables.adp 6 Jan 2017 09:18:42 -0000 1.1.2.15 @@ -12,14 +12,14 @@ Variables

Date and Time Variables

-
($‌Id: variables.html,v 1.30.2.12 2016/11/19 -09:21:55 gustafn Exp $)

By joel\@aufrecht.org +

($‌Id: variables.xml,v 1.3 2006/07/17 05:38:37 +torbenb Exp $)

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 12.1. Getting datetime from +

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,