MySQL Forums
Forum List  »  German

SQL Export nach csv aus doublefeldern liefert datum
Posted by: Gottfried Faaß
Date: September 22, 2021 06:58AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
SQL Export nach csv aus doublefeldern liefert datum
157
September 22, 2021 06:58AM


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.