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: "Cesar Alvarez" <c(dot)alvarezx66(at)gmail(dot)com>
Cc: <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-21 07:05:35
Message-ID: 000001c76b97$134d5f60$170211ac@LIONKING.COM (view raw or whole thread)
Lists: pgsql-novice
I am in INDIA

Tried with to_char but it does not take column name/actuall date value  as argument for date

With Regards
  ----- Original Message ----- 
  From: Cesar Alvarez 
  To: Ashish Karalkar 
  Cc: pgsql-novice(at)postgresql(dot)org 
  Sent: Wednesday, March 21, 2007 11:38 AM
  Subject: Re: [NOVICE] Formating Date Data Type?

  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.

In response to


pgsql-novice by date

Next:From: LeticiaDate: 2007-03-21 14:29:54
Subject: CHAR data type
Previous:From: Cesar AlvarezDate: 2007-03-21 06:08:00
Subject: Re: Formating Date Data Type?

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