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 -r1.4.2.9 -r1.4.2.10 --- openacs-4/packages/bug-tracker/tcl/bug-procs-oracle.xql 27 Jan 2005 02:29:32 -0000 1.4.2.9 +++ openacs-4/packages/bug-tracker/tcl/bug-procs-oracle.xql 1 Dec 2005 13:25:36 -0000 1.4.2.10 @@ -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,