Hallo,
Probier mal (ungetestet): INSERT INTO Tabelle_A (X,Y,Z,date)
VALUES (SELECT X,Y,Z, date as "2010-01-01 00:00" FROM Tabelle_A AS TA
WHERE TA.date like "%2010-07-14%")
MfG
tomgk
nicht angemeldet nicht angemeldetHallo,
Probier mal (ungetestet): INSERT INTO Tabelle_A (X,Y,Z,date)
VALUES (SELECT X,Y,Z, date as "2010-01-01 00:00" FROM Tabelle_A AS TA
WHERE TA.date like "%2010-07-14%")
MfG
tomgk