Postgres Pro
Downloads
Home   >   mailing lists

Re: Should I use CAST? - Mailing list pgsql-general

From Tom Lane
Subject Re: Should I use CAST?
Date
Msg-id 14161.1007399114@sss.pgh.pa.us
Whole thread Raw
In response to Should I use CAST?  ("Campano, Troy" <Troy.Campano@LibertyMutual.com>)
List pgsql-general
Tree view 
"Campano, Troy" <Troy.Campano@LibertyMutual.com> writes:
> Any ideas what I can do to make a VARCHAR column a date?
> All the dates are in this format: 10/23/2002

Use to_date().  See

http://www.ca.postgresql.org/users-lounge/docs/7.1/postgres/functions-formatting.html

            regards, tom lane

pgsql-general by date:

Previous
From: Doug McNaught
Date:
Subject: Re: Determining current database programmatically
Next
From: Thomas Lockhart
Date:
Subject: Re: interval