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

Re: Formating Date Data Type?

From: Cesar Alvarez <c(dot)alvarezx66(at)gmail(dot)com>
To: Ashish Karalkar <ashish(dot)karalkar(at)info-spectrum(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Formating Date Data Type?
Date: 2007-03-21 06:08:00
Message-ID: 4600CBC0.4090703@gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
shouldn't  windows make that format, with the regional Settings?
where are you developing your APP.


Ashish Karalkar wrote:
> Hello list,
>  
> I am storing date as '2007-04-15' in data base as YYYY-MM-DD
>  
> Now I want  to format this to 15-Apr-2007.
>  
> Is there any way
>  
> I tries to use extract function but it gives in only digit format 
> also  this function does not except column name as input
>  
>  
> Is there any way??
>  
> Thanks In advance.
>  


Attachment: c.alvarezx66.vcf
Description: text/x-vcard (120 bytes)

In response to

Responses

pgsql-novice by date

Next:From: Ashish KaralkarDate: 2007-03-21 07:05:35
Subject: Re: Formating Date Data Type?
Previous:From: Phillip SmithDate: 2007-03-21 04:29:17
Subject: Re: Formating Date Data Type?

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