← Back to branch summary

~hanno-stock/revu/updated-revu-workflow

« back to all changes in this revision

Viewing changes to profile.py

  • Committer: Siegfried-Angel Gevatter Pujals
  • Date: 2009-02-06 17:11:07 UTC
  • mfrom: (415.1.3 revu)
  • Revision ID: rainct@ubuntu.com-20090206171107-6u0vsmql134blo1b
Change the format of the dates, as proposed by Morten.

Show diffs side-by-side

added added

removed removed

Lines of Context:
profile.py
79
79
    
80
80
    sql = """
81
81
        SELECT upid, SourcePackage.name AS name,
82
 
            to_char(dateofupload, 'Month DD HH24:MI') AS date
 
82
            to_char(dateofupload, 'DD Mon YYYY HH24:MI') AS date
83
83
        FROM Upload 
84
84
        INNER JOIN Users 
85
85
            ON (Upload.usid=Users.usid) 
92
92
    
93
93
    sql = """
94
94
        SELECT cid, text, SourcePackage.name AS package, isadvocating,
95
 
            to_char(dateofcomment, 'Month DD HH24:MI') AS date
 
95
            to_char(dateofcomment, 'DD Mon YYYY HH24:MI') AS date
96
96
        FROM Comments
97
97
        INNER JOIN Users 
98
98
            ON (Comments.usid=Users.usid)