Re: date_format in postresql - Mailing list pgsql-sql

From Rod Taylor
Subject Re: date_format in postresql
Date
Msg-id 1090377577.12565.13.camel@jester
Whole thread Raw
In response to date_format in postresql  (azah azah <izza76@gmail.com>)
Responses Re: date_format in postresql
List 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




pgsql-sql by date:

Previous
From: "Iain"
Date:
Subject: Re: surrogate key or not?
Next
From: Jeff Boes
Date:
Subject: Inherited tables and new fields