Index: openacs-4/contrib/obsolete-packages/wap/sql/postgresql/wap-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/wap/sql/postgresql/wap-create.sql,v
diff -u -r1.1 -r1.1.4.1
--- openacs-4/contrib/obsolete-packages/wap/sql/postgresql/wap-create.sql	9 May 2001 18:54:48 -0000	1.1
+++ openacs-4/contrib/obsolete-packages/wap/sql/postgresql/wap-create.sql	16 Feb 2003 20:51:07 -0000	1.1.4.1
@@ -99,7 +99,7 @@
     new_id := acs_object__new (
       v_user_agent_id,          -- object_id
       ''wap_user_agent'',       -- object_type
-      current_time,             -- creation_date
+      current_timestamp,        -- creation_date
       v_creation_user,          -- creation_user
       v_creation_ip,            -- creation_ip
       null                      -- context_id
Index: openacs-4/packages/acs-lang/tcl/locale-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-lang/tcl/Attic/locale-procs-postgresql.xql,v
diff -u -r1.2 -r1.2.4.1
--- openacs-4/packages/acs-lang/tcl/locale-procs-postgresql.xql	4 May 2001 19:29:07 -0000	1.2
+++ openacs-4/packages/acs-lang/tcl/locale-procs-postgresql.xql	16 Feb 2003 20:53:36 -0000	1.2.4.1
@@ -6,7 +6,7 @@
 <fullquery name="ad_locale_system_tz_offset.system_offset">      
       <querytext>
       
-	select ( (current_time - timezone__local_to_utc (:system_timezone, current_time)) * 24 )
+	select ( (current_timestamp - timezone__local_to_utc (:system_timezone, current_timestamp)) * 24 )
 	
     
       </querytext>
Index: openacs-4/packages/acs-lang/www/format-test-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-lang/www/Attic/format-test-postgresql.xql,v
diff -u -r1.1 -r1.1.4.1
--- openacs-4/packages/acs-lang/www/format-test-postgresql.xql	2 May 2001 20:16:19 -0000	1.1
+++ openacs-4/packages/acs-lang/www/format-test-postgresql.xql	16 Feb 2003 20:52:46 -0000	1.1.4.1
@@ -4,7 +4,7 @@
  
 <fullquery name="lang_system_time_select">
     <querytext>
-	SELECT to_char(current_time, 'YYYY-MM-DD HH24:MI:SS') AS system_time
+	SELECT to_char(current_timestamp, 'YYYY-MM-DD HH24:MI:SS') AS system_time
     </querytext>
 </fullquery>
 	        
Index: openacs-4/packages/acs-lang/www/set-system-timezone-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-lang/www/Attic/set-system-timezone-postgresql.xql,v
diff -u -r1.1 -r1.1.4.1
--- openacs-4/packages/acs-lang/www/set-system-timezone-postgresql.xql	2 May 2001 20:16:19 -0000	1.1
+++ openacs-4/packages/acs-lang/www/set-system-timezone-postgresql.xql	16 Feb 2003 20:52:46 -0000	1.1.4.1
@@ -4,7 +4,7 @@
  
 <fullquery name="sysdate">
     <querytext>
-	select to_char(current_time, 'YYYY-MM-DD HH24:MI:SS')
+	select to_char(current_timestamp, 'YYYY-MM-DD HH24:MI:SS')
     </querytext>
 </fullquery>
 	        
Index: openacs-4/packages/acs-lang/www/test-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-lang/www/Attic/test-postgresql.xql,v
diff -u -r1.1 -r1.1.4.1
--- openacs-4/packages/acs-lang/www/test-postgresql.xql	2 May 2001 20:16:19 -0000	1.1
+++ openacs-4/packages/acs-lang/www/test-postgresql.xql	16 Feb 2003 20:52:46 -0000	1.1.4.1
@@ -5,7 +5,7 @@
 
 <fullquery name="lang_system_time_select">      
       <querytext>
-      SELECT to_char(current_time, 'YYYY-MM-DD HH24:MI:SS') AS system_time
+      SELECT to_char(current_timestamp, 'YYYY-MM-DD HH24:MI:SS') AS system_time
       </querytext>
 </fullquery>
 
Index: openacs-4/packages/acs-lang/www/timezone-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-lang/www/Attic/timezone-postgresql.xql,v
diff -u -r1.1 -r1.1.4.1
--- openacs-4/packages/acs-lang/www/timezone-postgresql.xql	2 May 2001 20:16:19 -0000	1.1
+++ openacs-4/packages/acs-lang/www/timezone-postgresql.xql	16 Feb 2003 20:52:46 -0000	1.1.4.1
@@ -4,7 +4,7 @@
  
 <fullquery name="lang_system_time_select">
     <querytext>
-	select to_char(current_time, 'YYYY-MM-DD HH24:MI:SS') AS system_time
+	select to_char(current_timestamp, 'YYYY-MM-DD HH24:MI:SS') AS system_time
     </querytext>
 </fullquery>
 	        
Index: openacs-4/packages/robot-detection/tcl/robot-detection-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/robot-detection/tcl/robot-detection-procs-postgresql.xql,v
diff -u -r1.1.4.1 -r1.1.4.2
--- openacs-4/packages/robot-detection/tcl/robot-detection-procs-postgresql.xql	9 Oct 2002 21:05:29 -0000	1.1.4.1
+++ openacs-4/packages/robot-detection/tcl/robot-detection-procs-postgresql.xql	16 Feb 2003 20:52:03 -0000	1.1.4.2
@@ -4,7 +4,7 @@
 
 <fullquery name="ad_update_robot_list.days_since_last_update">      
       <querytext>
-		select trunc(current_time - max(coalesce(modified_date, insertion_date))) from robots
+		select trunc(current_timestamp - max(coalesce(modified_date, insertion_date))) from robots
       </querytext>
 </fullquery>