Re: [SQL] type casting: varchar to date

2001-02-06 Thread Karel Zak
On Tue, 6 Feb 2001, J.Fernando Moyano wrote: > > Is there some way to do something like this ?? : Yes, select to_timestamp('hello 02-06-2001', '"hello "MM-DD-'); Karel

[SQL] type casting: varchar to date

2001-02-06 Thread J.Fernando Moyano
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