Re: Fetching as Date from a String

From: Thirumoorthy Bhuvneswari <tbhuvneswari(at)yahoo(dot)com>
To: Martijn van Oosterhout <kleptog(at)svana(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Fetching as Date from a String
Date: 2002-10-17 05:21:57
Message-ID: 20021017052157.65572.qmail@web13604.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hi,
Can u please give me an example for how to use
'to_char' or 'to_date' in the query. thanks.

bhuvana.
--- Martijn van Oosterhout <kleptog(at)svana(dot)org> wrote:
> Hi,
>
> The default data processing can be a bit confusing.
> It depend on the
> settings of "set datestyle", etc...
>
> For ultimate control, lookup to_date and to_char in
> the help. There you can
> specify the exactly format to use.
>
> Hope this helps,
>
> On Wed, Oct 16, 2002 at 09:22:38PM -0700,
> Thirumoorthy Bhuvneswari wrote:
> > hi,
> > I am using Postgresql-7.1 with RedHat Linux-7.1
> and
> > JDK-1.3.1. I am having a table named 'inv_table'
> with
> > a field 'inv_date' of datatype 'varchar'. But, the
> > field contains the records in the format
> > '05-10-02(dd-MM-yy)'. I created a view to take the
> > field like:
> > 'select inv_date::text::date from inv_table'. It
> > fetches the date field in the format
> > '2002-05-10(yyyy-MM-dd)'. ie, 'dd' part of the
> string
> > is taken as the 'MM' here and vice versa. But,
> this
> > fetching works fine for dates above '12-10-2002'.
> > Is there a way to specify the format of the string
> in
> > the 'Select' query itself. Please help me. thanks.
> >
> > bhuvana.
> >
> > __________________________________________________
> > Do you Yahoo!?
> > Faith Hill - Exclusive Performances, Videos & More
> > http://faith.yahoo.com
> >
> > ---------------------------(end of
> broadcast)---------------------------
> > TIP 5: Have you checked our extensive FAQ?
> >
> >
> http://www.postgresql.org/users-lounge/docs/faq.html
>
> --
> Martijn van Oosterhout <kleptog(at)svana(dot)org>
> http://svana.org/kleptog/
> > There are 10 kinds of people in the world, those
> that can do binary
> > arithmetic and those that can't.

__________________________________________________
Do you Yahoo!?
Faith Hill - Exclusive Performances, Videos & More
http://faith.yahoo.com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2002-10-17 05:26:42 Re: Fetching as Date from a String
Previous Message Martijn van Oosterhout 2002-10-17 04:45:05 Re: Fetching as Date from a String