Re: Fetching as Date from a String

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@svana.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.