date_format in postresql

Hi,
I want convert from mysql to postresql,
in mysql, query to database using the code as below:

date_format(submittime, "%W %M %e, %Y - %r")

what the format query in postresql? Anyone who can help me?

Thanks
-Azah-

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)