pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedtype casting: varchar to date
2+ messages / 2 participants
[nested] [flat]
* type casting: varchar to date
@ 2001-02-06 18:20 J.Fernando Moyano <txinete@wanadoo.es>
2001-02-06 18:42 ` Re: type casting: varchar to date Karel Zak <zakkr@zf.jcu.cz>
0 siblings, 1 reply; 2+ messages in thread
From: J.Fernando Moyano @ 2001-02-06 18:20 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: type casting: varchar to date
2001-02-06 18:20 type casting: varchar to date J.Fernando Moyano <txinete@wanadoo.es>
@ 2001-02-06 18:42 ` Karel Zak <zakkr@zf.jcu.cz>
0 siblings, 0 replies; 2+ messages in thread
From: Karel Zak @ 2001-02-06 18:42 UTC (permalink / raw)
To: J.Fernando Moyano <txinete@wanadoo.es>; +Cc: pgsql-sql
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-YYYY');
Karel
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2001-02-06 18:42 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-02-06 18:20 type casting: varchar to date J.Fernando Moyano <txinete@wanadoo.es>
2001-02-06 18:42 ` Karel Zak <zakkr@zf.jcu.cz>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox