Thread: date_format in postresql

date_format in postresql

From
azah azah
Date:
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-

Re: date_format in postresql

From
Christopher Kings-Lynne
Date:
> what the format query in postresql? Anyone who can help me?

http://www.postgresql.org/docs/7.4/static/functions-formatting.html

Chris