SQL Export nach csv aus doublefeldern liefert datum
Hallo !
Ich habe das Problem, daß ein sql export in der Form
SELECT 'partnumber','manufacturer','price'
UNION
SELECT partnumber,manufacturer,price
FROM Product where price > 0
INTO OUTFILE 'C:/export_preis.csv'
FIELDS ENCLOSED BY '"' TERMINATED BY ';' ESCAPED BY '"'
LINES TERMINATED BY '\r\n';
im Feld price des CSV ein Datum z.b 11.Sept liefert
falls der Inhalt des double feldes price 11,9 ist
also einem Datum ähnelt.
36.59 ok
34.95 ok
30.38 ok
19.96 ok
12 ok
Aug 16 ( 8,16 ) ?
03. Jan ( 3,01 ) ?
14. Jan ( 14,1) ?
mit Formatierungsoptionen bin ich nicht weiter gekommen.
SELECT partnumber,manufacturer,price
FROM Product where price > 0;
liefert durchaus erwartbare werte.
Subject
Views
Written By
Posted
SQL Export nach csv aus doublefeldern liefert datum
157
September 22, 2021 06:58AM
86
September 22, 2021 10:31AM
69
September 22, 2021 10:49AM
75
September 22, 2021 12:49PM
81
September 23, 2021 05:41AM
Sorry, only registered users may post in this forum.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.