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: (view raw, whole thread or download thread mbox)
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


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-2017 The PostgreSQL Global Development Group