Index: openacs-4/packages/bug-tracker/tcl/bug-procs-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/tcl/bug-procs-oracle.xql,v diff -u -N -r1.8 -r1.9 --- openacs-4/packages/bug-tracker/tcl/bug-procs-oracle.xql 24 Feb 2005 13:33:03 -0000 1.8 +++ openacs-4/packages/bug-tracker/tcl/bug-procs-oracle.xql 1 Dec 2005 13:25:27 -0000 1.9 @@ -11,14 +11,14 @@ b.summary, b.component_id, b.creation_date, - to_char(b.creation_date, 'fmMM/DDfm/YYYY') as creation_date_pretty, + to_char(b.creation_date, 'YYYY-MM-DD HH24:MI:SS') as creation_date_pretty, b.resolution, b.user_agent, b.found_in_version, b.found_in_version, b.fix_for_version, b.fixed_in_version, - to_char(sysdate, 'fmMM/DDfm/YYYY') as now_pretty + to_char(sysdate, 'YYYY-MM-DD HH24:MI:SS') as now_pretty from bt_bugs b where b.bug_id = :bug_id @@ -120,7 +120,7 @@ b.comment_format, b.component_id, b.creation_date, - to_char(b.creation_date, 'fmMM/DDfm/YYYY') as creation_date_pretty, + to_char(b.creation_date, 'YYYY-MM-DD HH24:MI:SS') as creation_date_pretty, b.creation_user as submitter_user_id, submitter.first_names as submitter_first_names, submitter.last_name as submitter_last_name, @@ -170,7 +170,7 @@ b.comment_format, b.component_id, b.creation_date, - to_char(b.creation_date, 'fmMM/DDfm/YYYY') as creation_date_pretty, + to_char(b.creation_date, 'YYYY-MM-DD HH24:MI:SS') as creation_date_pretty, b.creation_user as submitter_user_id, submitter.first_names as submitter_first_names, submitter.last_name as submitter_last_name, Index: openacs-4/packages/bug-tracker/tcl/bug-procs-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/tcl/bug-procs-postgresql.xql,v diff -u -N -r1.10 -r1.11 --- openacs-4/packages/bug-tracker/tcl/bug-procs-postgresql.xql 24 Feb 2005 13:33:03 -0000 1.10 +++ openacs-4/packages/bug-tracker/tcl/bug-procs-postgresql.xql 1 Dec 2005 13:25:27 -0000 1.11 @@ -11,14 +11,14 @@ b.summary, b.component_id, to_char(b.creation_date,'YYYY-MM-DD HH24:MI:SS') as creation_date, - to_char(b.creation_date, 'fmMM/DDfm/YYYY') as creation_date_pretty, + to_char(b.creation_date, 'YYYY-MM-DD HH24:MI:SS') as creation_date_pretty, b.resolution, b.user_agent, b.found_in_version, b.found_in_version, b.fix_for_version, b.fixed_in_version, - to_char(now(), 'fmMM/DDfm/YYYY') as now_pretty + to_char(now(), 'YYYY-MM-DD HH24:MI:SS') as now_pretty from bt_bugs b where b.bug_id = :bug_id @@ -108,7 +108,7 @@ b.comment_format, b.component_id, b.creation_date, - to_char(b.creation_date, 'fmMM/DDfm/YYYY') as creation_date_pretty, + to_char(b.creation_date, 'YYYY-MM-DD HH24:MI:SS') as creation_date_pretty, b.creation_user as submitter_user_id, submitter.first_names as submitter_first_names, submitter.last_name as submitter_last_name, @@ -158,7 +158,7 @@ b.comment_format, b.component_id, to_char(b.creation_date,'YYYY-MM-DD HH24:MI:SS') as creation_date, - to_char(b.creation_date, 'fmMM/DDfm/YYYY') as creation_date_pretty, + to_char(b.creation_date, 'YYYY-MM-DD HH24:MI:SS') as creation_date_pretty, b.creation_user as submitter_user_id, submitter.first_names as submitter_first_names, submitter.last_name as submitter_last_name, Index: openacs-4/packages/bug-tracker/tcl/bug-procs.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/tcl/bug-procs.xql,v diff -u -N -r1.5 -r1.6 --- openacs-4/packages/bug-tracker/tcl/bug-procs.xql 24 Feb 2005 13:33:04 -0000 1.5 +++ openacs-4/packages/bug-tracker/tcl/bug-procs.xql 1 Dec 2005 13:25:27 -0000 1.6 @@ -41,7 +41,7 @@ actor.last_name as actor_last_name, actor.email as actor_email, ba.action_date, - to_char(ba.action_date, 'fmMM/DDfm/YYYY') as action_date_pretty, + to_char(ba.action_date, 'YYYY-MM-DD HH24:MI:SS') as action_date_pretty, ba.comment_s, ba.comment_format from bt_bug_actions ba, Index: openacs-4/packages/bug-tracker/tcl/bug-search-procs.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/tcl/bug-search-procs.tcl,v diff -u -N -r1.2 -r1.3 --- openacs-4/packages/bug-tracker/tcl/bug-search-procs.tcl 26 Jul 2004 13:10:25 -0000 1.2 +++ openacs-4/packages/bug-tracker/tcl/bug-search-procs.tcl 1 Dec 2005 13:25:27 -0000 1.3 @@ -104,8 +104,8 @@ submitter.last_name as submitter_last_name, submitter.email as submitter_email, acs_objects.creation_date, - to_char(acs_objects.creation_date, 'fmMM/DDfm/YYYY') as creation_date_pretty, - to_char(now(), 'fmMM/DDfm/YYYY') as now_pretty + to_char(acs_objects.creation_date, 'YYYY-MM-DD HH24:MI:SS') as creation_date_pretty, + to_char(now(), 'YYYY-MM-DD HH24:MI:SS') as now_pretty from bt_patches, acs_objects, cc_users submitter, @@ -133,7 +133,7 @@ actor.last_name as actor_last_name, actor.email as actor_email, bt_patch_actions.action_date, - to_char(bt_patch_actions.action_date, 'fmMM/DDfm/YYYY') as action_date_pretty, + to_char(bt_patch_actions.action_date, 'YYYY-MM-DD HH24:MI:SS') as action_date_pretty, bt_patch_actions.comment_text, bt_patch_actions.comment_format from bt_patch_actions, Index: openacs-4/packages/bug-tracker/tcl/bug-tracker-procs-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/tcl/bug-tracker-procs-oracle.xql,v diff -u -N -r1.5 -r1.6 --- openacs-4/packages/bug-tracker/tcl/bug-tracker-procs-oracle.xql 24 Feb 2005 13:33:04 -0000 1.5 +++ openacs-4/packages/bug-tracker/tcl/bug-tracker-procs-oracle.xql 1 Dec 2005 13:25:27 -0000 1.6 @@ -16,14 +16,14 @@ b.component_id, c.component_name, o.creation_date, - to_char(o.creation_date, 'fmMM/DDfm/YYYY') as creation_date_pretty, + to_char(o.creation_date, 'YYYY-MM-DD HH24:MI:SS') as creation_date_pretty, st.pretty_name as status, b.resolution, b.user_agent, b.found_in_version, b.fix_for_version, b.fixed_in_version, - to_char(sysdate, 'fmMon/DDfm/YYYY') as now_pretty + to_char(sysdate, 'YYYY-MM-DD HH24:MI:SS') as now_pretty from bt_bugs b, acs_objects o, bt_components c, Index: openacs-4/packages/bug-tracker/tcl/bug-tracker-procs-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/tcl/bug-tracker-procs-postgresql.xql,v diff -u -N -r1.5 -r1.6 --- openacs-4/packages/bug-tracker/tcl/bug-tracker-procs-postgresql.xql 28 Feb 2005 09:27:06 -0000 1.5 +++ openacs-4/packages/bug-tracker/tcl/bug-tracker-procs-postgresql.xql 1 Dec 2005 13:25:27 -0000 1.6 @@ -17,14 +17,14 @@ b.component_id, c.component_name, o.creation_date, - to_char(o.creation_date, 'fmMM/DDfm/YYYY') as creation_date_pretty, + to_char(o.creation_date, 'YYYY-MM-DD HH24:MI:SS') as creation_date_pretty, st.pretty_name as status, b.resolution, b.user_agent, b.found_in_version, b.fix_for_version, b.fixed_in_version, - to_char(now(), 'fmMon/DDfm/YYYY') as now_pretty + to_char(now(), 'YYYY-MM-DD HH24:MI:SS') as now_pretty from bt_bugs b, acs_objects o, bt_components c,