Quick Links

date_format in postresql

From:	azah azah <izza76(at)gmail(dot)com>
To:	pgsql-sql(at)postgresql(dot)org, pgsql-php(at)postgresql(dot)org
Subject:	date_format in postresql
Date:	2004-07-21 00:55:03
Message-ID:	235b1a28040720175570f4225a@mail.gmail.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-php pgsql-sql

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-

Responses

Re: date_format in postresql at 2004-07-21 01:45:29 from Christopher Kings-Lynne
Re: date_format in postresql at 2004-07-21 02:39:38 from Rod Taylor

Browse pgsql-php by date

	From	Date	Subject
Next Message	Christopher Kings-Lynne	2004-07-21 01:45:29	Re: date_format in postresql
Previous Message	Christopher Kings-Lynne	2004-07-20 08:34:47	Re: Escape string in postresql

Browse pgsql-sql by date

	From	Date	Subject
Next Message	Iain	2004-07-21 01:31:03	Re: surrogate key or not?
Previous Message	Lars Erik Thorsplass	2004-07-20 22:03:32	Re: [GENERAL] Stored procedures and "pseudo" fields..