[Slashcode-development] sub Slash::DB::PostgreSQL::getSubmissionForUser

[Alessio B. <al...@al...>]

package Slash::DB::{Postgre|My}SQL, routine getSubmissionForUser,
updated from CVS.

I am a little confused by the SELECT:

in PostgreSQL.pm:

SELECT subid,subj,date_format($dateformat,'m/d  H:i') [...]

in MySQL.pm:

SELECT subid,subj,time [...]

and later

formatDate($submission, 2, 2, '%m/%d  %H:%M');

in Perl.

What is correct? The SQL line for PostgreSQL sure it's not :-)
I believe that date_format should be to_char and 'm/d H:i' with '%'s, at
least.

-- 
Alessio F. Bragadini		al...@al...
APL Financial Services		http://village.albourne.com
Nicosia, Cyprus		 	phone: +357-2-755750

"It is more complicated than you think"
		-- The Eighth Networking Truth from RFC 1925