Index: openacs-4/packages/assessment/lib/assessment-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/lib/assessment-oracle.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/assessment/lib/assessment-oracle.xql 12 Jun 2006 03:30:09 -0000 1.1
+++ openacs-4/packages/assessment/lib/assessment-oracle.xql 20 Nov 2017 16:56:36 -0000 1.2
@@ -29,36 +29,5 @@
-
-
-
- update as_sessions
- set creation_datetime = sysdate
- where session_id = :session_id
- and creation_datetime is null
-
-
-
-
-
-
-
- UPDATE as_sessions
- SET last_mod_datetime = sysdate
- WHERE session_id = :session_id
-
-
-
-
-
-
-
- UPDATE as_sessions
- SET completed_datetime = sysdate
- WHERE session_id = :session_id
-
-
-
-
Index: openacs-4/packages/assessment/lib/assessment-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/lib/assessment-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/assessment/lib/assessment-postgresql.xql 12 Jun 2006 03:30:09 -0000 1.1
+++ openacs-4/packages/assessment/lib/assessment-postgresql.xql 20 Nov 2017 16:56:36 -0000 1.2
@@ -28,37 +28,6 @@
and d.section_id = m.section_id
-
-
-
-
+
- update as_sessions
- set creation_datetime = NOW()
- where session_id = :session_id
- and creation_datetime is null
-
-
-
-
-
-
-
- UPDATE as_sessions
- SET last_mod_datetime = NOW()
- WHERE session_id = :session_id
-
-
-
-
-
-
-
- UPDATE as_sessions
- SET completed_datetime = NOW()
- WHERE session_id = :session_id
-
-
-
-
Index: openacs-4/packages/assessment/lib/assessment.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/lib/assessment.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/assessment/lib/assessment.xql 13 Nov 2006 18:24:00 -0000 1.2
+++ openacs-4/packages/assessment/lib/assessment.xql 20 Nov 2017 16:56:36 -0000 1.3
@@ -101,4 +101,36 @@
+
+
+
+ update as_sessions
+ set creation_datetime = current_timestamp
+ where session_id = :session_id
+ and creation_datetime is null
+
+
+
+
+
+
+
+ UPDATE as_sessions
+ SET last_mod_datetime = current_timestamp
+ WHERE session_id = :session_id
+
+
+
+
+
+
+
+ UPDATE as_sessions
+ SET completed_datetime = current_timestamp
+ WHERE session_id = :session_id
+
+
+
+
+