Please help me.. problem in to_char - Mailing list pgsql-sql

From azah azah
Subject Please help me.. problem in to_char
Date
Msg-id 235b1a2804072101335eda05fd@mail.gmail.com
Whole thread Raw
Responses Re: Please help me.. problem in to_char  (Markus Bertheau <twanger@bluetwanger.de>)
Re: Please help me.. problem in to_char  (Theodore Petrosky <tedpet5@yahoo.com>)
List pgsql-sql
Hi, 
I want convert from mysql to postresql, previously
in mysql the code as below:

SELECT t2.id, t2.name, date_format(t1.created,\'%W %M %e, %Y - %r\') 

In postresql no date_format function, we need to use to_char function
but it still work because still need to put ::date such as
SELECT to_char('2005-03-27'::date,'DD/MM/YYYY');

How can i put ::date beside t1.created to get the output?
Any idea??


pgsql-sql by date:

Previous
From: Josh Berkus
Date:
Subject: Re: surrogate key or not?
Next
From: sad
Date:
Subject: Re: surrogate key or not?