Changeset 61 for trunk/lib/Vote/Model

Timestamp:

03/17/09 19:11:33 (15 years ago)

Author:

nanardon

Message:

• improve admin page

File:

• trunk/lib/Vote/Model/Vote.pm (modified) (1 diff)

trunk/lib/Vote/Model/Vote.pm

@@ -165 +165 @@
     my $sth = $self->db->prepare_cached(
         q{
-        select * from poll where id = ?
+        select *,
+        to_char("start", 'DD/MM/YYYY') as dstart,
+        to_char("start", 'HH24:MI:SS') as hstart,
+        to_char("end", 'DD/MM/YYYY') as dend,
+        to_char("end", 'HH24:MI:SS') as hend
+        from poll where id = ?
         }
     );