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.28.2.1 -r1.28.2.2 --- openacs-4/packages/acs-core-docs/www/variables.html 12 Jun 2011 20:03:49 -0000 1.28.2.1 +++ openacs-4/packages/acs-core-docs/www/variables.html 12 Jun 2011 20:52:57 -0000 1.28.2.2 @@ -1,15 +1,15 @@ -Variables
Alex logo
Prev Chapter 9. Engineering Standards Next

Variables

Date and Time Variables

($Id$)

By joel@aufrecht.org

+Variables
Alex logo
Prev Chapter 10. 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 9.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 10.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,
           ...
     ...
 } {
     set mydate_ansi [lc_time_system_to_conn $mydate_ansi]
     set mydate_pretty [lc_time_fmt $mydate_ansi "%x %X"]
 }
-
Prev Home Next
PL/SQL Standards Up Automated Testing
docs@openacs.org
View comments on this page at openacs.org
+
Prev Home Next
ACS File Naming and Formatting Standards Up Automated Testing
docs@openacs.org
View comments on this page at openacs.org