pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
type 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