#3 pxview: change date formats?

[Anonymous]

Hi,

I'm using pxview to read pdox tables and output them
to sql to import into MySQL.

Pxview is agreat tool and works vewry well (thanks)!

I've a problem though, pdox stores dates in a different
format, so pxview generates SQL like this:

insert into is_trans values ('BORA01', 38756, 39201040,
'03.07.2004', 'CFR', 339.3, 'EUR', NULL);

But I need to have :

insert into is_trans values ('BORA01', 38756, 39201040,
'2004.04.03', 'CFR', 339.3, 'EUR', NULL);

I've not yet found a function whihc mysql to to this, are
there are hacks you suggest on the pxview side?

Thanks in advance,

Sean