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