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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-php pgsql-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

Browse pgsql-php by date

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

Browse pgsql-sql by date

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