Thanks Karel,
Good call, you guessed it. I was just using my Oracle knowledge of
the to_date and applying it to the results I was expecting in pgsql. Guess I
should not make those assumptions
-Original Message-
From: Karel Zak [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October
Thanks Tom that worked great.
I guess I should have not skipped the
FM prefix section of the date conversion doc.
drw_dev-> to_timestamp(dt, 'FMMonth dd, ') from test_date;
dt | to_date | to_timestamp
++
March 11,
Can someone tell me if this is a bug with the date functions or am I using
them incorrectly?
If anyone has a workaround for this I could use some help this data
conversion.
dev=> create table test_date (dt varchar(100));
CREATE
dev=> insert into test_date values ('March 11, 1997');
INSERT 706020
