type casting: varchar to date

From: "J(dot)Fernando Moyano" <txinete(at)wanadoo(dot)es>
To: pgsql-sql(at)postgresql(dot)org
Subject: type casting: varchar to date
Date: 2001-02-06 18:20:57
Message-ID: 01020619205704.01568@txino.mikasa.eh
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


Is there some way to do something like this ?? :

crate table t (
a varchar(12),
b date
);

select (a::date-b) from t;

ERROR: cannot cast type 'varchar' to 'date'.

Thanks ....

--
Fer

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message jkakar 2001-02-06 18:39:39 timestamp- milliseconds since epoch output
Previous Message Jie Liang 2001-02-06 18:18:58 Re: Search