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

Re: Formating Date Data Type?

From: "Ashish Karalkar" <ashish(dot)karalkar(at)info-spectrum(dot)com>
To: "Michael Fuhr" <mike(at)fuhr(dot)org>
Cc: "Cesar Alvarez" <c(dot)alvarezx66(at)gmail(dot)com>, <pgsql-novice(at)postgresql(dot)org>, "Phillip Smith" <phillip(dot)smith(at)weatherbeeta(dot)com(dot)au>
Subject: Re: Formating Date Data Type?
Date: 2007-03-22 04:41:25
Message-ID: 004601c76c3d$9ce16310$170211ac@LIONKING.COM (view raw or flat)
Thread:
Lists: pgsql-novice
Thanks Michael ,
It works.
With Regards
Ashish....
----- Original Message ----- 
From: "Michael Fuhr" <mike(at)fuhr(dot)org>
To: "Ashish Karalkar" <ashish(dot)karalkar(at)info-spectrum(dot)com>
Cc: "Cesar Alvarez" <c(dot)alvarezx66(at)gmail(dot)com>; <pgsql-novice(at)postgresql(dot)org>; 
"Phillip Smith" <phillip(dot)smith(at)weatherbeeta(dot)com(dot)au>
Sent: Wednesday, March 21, 2007 8:10 PM
Subject: Re: [NOVICE] Formating Date Data Type?


> On Wed, Mar 21, 2007 at 12:35:35PM +0530, Ashish Karalkar wrote:
>> Tried with to_char but it does not take column name/actuall date
>> value  as argument for date
>
> Please show exactly what you tried and what the result was.  Does
> the following help?
>
> test=> create table test (d date);
> CREATE TABLE
> test=> insert into test values ('2007-04-15');
> INSERT 0 1
> test=> select to_char(d, 'DD-Mon-YYYY') from test;
>   to_char
> -------------
> 15-Apr-2007
> (1 row)
>
> test=> select to_char('2007-4-15'::date, 'DD-Mon-YYYY');
>   to_char
> -------------
> 15-Apr-2007
> (1 row)
>
> -- 
> Michael Fuhr 


In response to

pgsql-novice by date

Next:From: stephencDate: 2007-03-22 19:56:35
Subject: installing on windows XP
Previous:From: Martijn van OosterhoutDate: 2007-03-21 22:18:41
Subject: Re: can't trace error!!!

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