Index: openacs-4/packages/lars-blogger/tcl/rss-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/lars-blogger/tcl/rss-procs-oracle.xql,v
diff -u -r1.1 -r1.1.2.1
--- openacs-4/packages/lars-blogger/tcl/rss-procs-oracle.xql	19 Aug 2002 21:52:59 -0000	1.1
+++ openacs-4/packages/lars-blogger/tcl/rss-procs-oracle.xql	24 Oct 2002 08:57:25 -0000	1.1.2.1
@@ -19,6 +19,8 @@
                          posted_date,
                          to_char(posted_date, 'YYYY-MM-DD') as posted_date_string,
                          to_char(posted_date, 'HH:MI') as posted_time_string,
+                         -6 as tzoffset_hour,
+                         0 as tzoffset_minute,
                          to_char(entry_date, 'DD Mon YYYY hh12:MI am') as entry_date_pretty,
                          to_char(entry_date, 'YYYY/MM/') as entry_archive_url
                   from pinds_blog_entries
Index: openacs-4/packages/lars-blogger/tcl/rss-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/lars-blogger/tcl/rss-procs-postgresql.xql,v
diff -u -r1.1 -r1.1.2.1
--- openacs-4/packages/lars-blogger/tcl/rss-procs-postgresql.xql	19 Aug 2002 21:52:59 -0000	1.1
+++ openacs-4/packages/lars-blogger/tcl/rss-procs-postgresql.xql	24 Oct 2002 08:57:25 -0000	1.1.2.1
@@ -18,8 +18,11 @@
                    posted_date,
                    to_char(posted_date, 'YYYY-MM-DD') as posted_date_string,
                    to_char(posted_date, 'HH:MI') as posted_time_string,
+                   extract(timezone_hour from now()) as tzoffset_hour,
+                   extract(timezone_minute from now()) as tzoffset_minute,
                    to_char(entry_date, 'DD Mon YYYY hh12:MI am') as entry_date_pretty,
                    to_char(entry_date, 'YYYY/MM/') as entry_archive_url
+    
             from pinds_blog_entries
             where package_id = :package_id
             and draft_p = 'f'
Index: openacs-4/packages/lars-blogger/tcl/rss-procs.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/lars-blogger/tcl/rss-procs.tcl,v
diff -u -r1.2 -r1.2.2.1
--- openacs-4/packages/lars-blogger/tcl/rss-procs.tcl	14 Sep 2002 16:40:33 -0000	1.2
+++ openacs-4/packages/lars-blogger/tcl/rss-procs.tcl	24 Oct 2002 08:57:25 -0000	1.2.2.1
@@ -43,6 +43,8 @@
     set counter 0
 
     db_foreach blog_rss_items { *SQL* } {
+        set TZoffset [format "%+03d:%02d" $tzoffset_hour $tzoffset_minute]
+        
         set entry_url "[ad_url]${package_url}archive/${entry_archive_url}#blog-entry-$entry_id"
 
         set content [ns_adp_parse -string $content]
@@ -56,7 +58,7 @@
             set description $content_as_text
         }
 
-        lappend items [list link $entry_url title $title description $description value $content timestamp "${posted_date_string}T${posted_time_string}-0600"]
+        lappend items [list link $entry_url title $title description $description value $content timestamp "${posted_date_string}T${posted_time_string}$TZoffset"]
         if { $counter == 0 } {
             set column_array(channel_lastBuildDate) $entry_date_pretty
             incr counter
@@ -92,5 +94,3 @@
 
     return $last_update
 }
-
-