Thread: importing dates

importing dates

From
thefronny@gmail.com
Date:
I need to copy some data that includes an date as YYYY/MM/DD. Is there
a method I can do this and replace the "/" with "-" on the fly in the
copy command string?

thx,

tf

Re: importing dates

From
"Scott Marlowe"
Date:
On Tue, Aug 26, 2008 at 2:24 PM,  <thefronny@gmail.com> wrote:
> I need to copy some data that includes an date as YYYY/MM/DD. Is there
> a method I can do this and replace the "/" with "-" on the fly in the
> copy command string?

You shouldn't need to.  Pgsql should accept yyyy/mm/dd as valid date
format and load it right in.