Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-phppgsql-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

pgsql-php by date

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

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group