Re: Should I use CAST?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Campano, Troy" <Troy(dot)Campano(at)LibertyMutual(dot)com>
Cc: "Pgsql-General (pgsql-general(at)postgresql(dot)org)" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Should I use CAST?
Date: 2001-12-03 17:05:14
Message-ID: 14161.1007399114@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Campano, Troy" <Troy(dot)Campano(at)LibertyMutual(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Yuri A. Kabaenkov 2001-12-03 17:09:53 Re: interval
Previous Message Thomas Lockhart 2001-12-03 17:01:45 Re: interval