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 flat)
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
Ashish
  ----- 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

Responses

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