Store Unix timestamps in the database, rather than SQL ones.

[odin-cgi] / bin / pastebin.userv

diff --git a/bin/pastebin.userv b/bin/pastebin.userv
index 3c87cb56cebff2dbc8d2fe3df26ee90db425ba08..ed7ba7a147ff0ac300a9cf555f620e9c2002ce06 100755 (executable)
--- a/bin/pastebin.userv
+++ b/bin/pastebin.userv
@@ -42,11 +42,10 @@ EOF
   @ARGV == 0 or Odin::fail "usage: list";
   my $db = Odin::open_db;
   for my $r (@{$db->selectall_arrayref
-               ("SELECT " . Odin::sql_timestamp($db, "stamp") .
-                     ", tag, lang, title
+               ("SELECT tag, stamp, lang, title
                  FROM odin_pastebin WHERE owner = ?
                  ORDER BY stamp", undef, $Odin::WHO)}) {
-    my ($stamp, $tag, $lang, $title) = @$r;
+    my ($tag, $stamp, $lang, $title) = @$r;
     my $t = strftime "%Y-%m-%d %H:%M:%S %z", localtime $stamp;
     printf "%-25s  %-12s  %-16s  %s\n",
       $t, $tag, $lang, encode locale => $title;