Variables

- - -

Date and Time Variables

- -<authorblurb> -

($Id$)

- -

By joel@aufrecht.org

-</authorblurb> - -

Starting with OpenACS 5.0 and the introduction of acs-lang, +Variables

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 12.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,
           ...
     ...
 } {
     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