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

Re: help with to_date and to_char

From: Thomas F(dot)O'Connell <tfo(at)sitening(dot)com>
To: Lori <lorid(at)dri(dot)edu>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: help with to_date and to_char
Date: 2004-10-19 21:27:02
Message-ID: 9E1E7300-2215-11D9-A5E5-000D93AE0944@sitening.com (view raw or flat)
Thread:
Lists: pgsql-sql
There might be a better way, but this should do what you want. And I 
think that you can safely replace '05' with when_month.

select to_char( to_date( '05' || '/' || to_char( current_date, 
'DD/YYYY' ), 'MM/DD/YYYY' ), 'MON' );

-tfo

--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005

On Oct 12, 2004, at 7:20 PM, Lori wrote:

> Im trying to do something very simple
> I have a field called when_month (integer )
> so I want to get the month name for the integer
>
> this comes close to what I want
> update mytable set myfield=to_char(current_timestamp,'MON');
>
> the result is myfield is set to OCT
> which is close to what I want but when I try to use a variable
> update mytable set myfield=to_char(when_month,'MON');
> or a char with value of '05' or '5'
> update mytable set myfield=to_char('05','MON');
> get error:
> update mytable set myfield=to_date(when_month,'MON');
> update mytable set myfield=to_char('05','MON');
> as well as
> update mytable set full_month= to_date('01/'05'/2004','DDMONYYYY');
> all get errors
>
> Please can anyone help?
>
> ---------------------------(end of 
> broadcast)---------------------------
> TIP 8: explain analyze is your friend


In response to

Responses

pgsql-sql by date

Next:From: Tom LaneDate: 2004-10-19 21:31:55
Subject: Re: the problem of createlang!
Previous:From: Mark GibsonDate: 2004-10-19 14:50:08
Subject: Re: Aggregate Function with Argument

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