X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id E1292D1B1B3
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 21 Jul 2004 09:35:26 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 02078-09
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 21 Jul 2004 12:35:08 +0000 (GMT)
Received: from web41004.mail.yahoo.com (web41004.mail.yahoo.com [66.218.93.3])
	by svr1.postgresql.org (Postfix) with SMTP id 792A8D1B16A
	for <pgsql-sql@postgresql.org>; Wed, 21 Jul 2004 09:35:03 -0300 (ADT)
Message-ID: <20040721123506.92469.qmail@web41004.mail.yahoo.com>
Received: from [151.204.106.102] by web41004.mail.yahoo.com via HTTP;
	Wed, 21 Jul 2004 05:35:06 PDT
Date: Wed, 21 Jul 2004 05:35:06 -0700 (PDT)
From: Theodore Petrosky <tedpet5@yahoo.com>
Subject: Re: Please help me.. problem in to_char
To: azah azah <izza76@gmail.com>, pgsql-sql@postgresql.org
In-Reply-To: <235b1a2804072101335eda05fd@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=1.1 tagged_above=0.0 required=5.0
	tests=MAILTO_TO_SPAM_ADDR
X-Spam-Level: *
X-Archive-Number: 200407/149
X-Sequence-Number: 18401


what kind of column is t1.created? It appears that it
is a text column and the format looks like a date. Is
this correct or is it a date? I need more information
about your table structure. 

What about:

SELECT t2.id, t2.name, to_char(cast (t1.created as
date),'DD/MM/YYYY')

but the other '::' should work also.

extremedb=> SELECT to_char(cast ('12/4/2004' as
date),'DD/MM/YYYY');
  to_char   
------------
 04/12/2004
(1 row)


extremedb=> SELECT
to_char('12/4/2004'::date,'DD/MM/YYYY');
  to_char   
------------
 04/12/2004
(1 row)



I have a table with a timestamp in it called
createdate..


\d clientinfo
                 Table "public.clientinfo"
     Column      |           Type           |  
Modifiers   
-----------------+--------------------------+-----
 acode            | text                            |
not null
 createdate      | timestamp with time zone | default
now()


extremedb=> SELECT to_char(cast (clientinfo.createdate
as date),'DD/MM/YYYY') from clientinfo;
  to_char   
------------
 14/07/2004
 14/07/2004
 14/07/2004



Ted

--- azah azah <izza76@gmail.com> wrote:
> 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??
> 
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to
> majordomo@postgresql.org
> 


		
__________________________________
Do you Yahoo!?
Yahoo! Mail - 50x more storage than other providers!
http://promotions.yahoo.com/new_mail