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

Re: date_format in postresql

From: Rod Taylor <pg(at)rbt(dot)ca>
To: azah azah <izza76(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: date_format in postresql
Date: 2004-07-21 02:39:38
Message-ID: 1090377577.12565.13.camel@jester (view raw or flat)
Thread:
Lists: pgsql-phppgsql-sql
On Tue, 2004-07-20 at 20:55, azah azah wrote:
> 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")

to_char(submittime, 'format string')

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



In response to

Responses

pgsql-php by date

Next:From: azah azahDate: 2004-07-21 03:53:14
Subject: Re: date_format in postresql
Previous:From: Christopher Kings-LynneDate: 2004-07-21 01:45:29
Subject: Re: date_format in postresql

pgsql-sql by date

Next:From: azah azahDate: 2004-07-21 03:53:14
Subject: Re: date_format in postresql
Previous:From: Christopher Kings-LynneDate: 2004-07-21 01:45:29
Subject: Re: date_format in postresql

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