importing dates
Started by semi-ambivalentover 17 years ago2 messagesgeneral
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
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.