Error - Invalid Date value
Hi guys,
I'm trying to import my local database using a query, but I receive this error:
[Line: 2 Field: 2] (Mar 15 2018 12:00AM) -ERROR: Invalid Date value
The data found at the row 2 has invalid data for the given configuration
This is my query:
SELECT D1.ZP4_NUM, D1.ZP4_FUN, CONVERT(VARCHAR,CONVERT(DATETIME,D1.ZP4_DATAS),0) AS ZP4_DATAS,
(CASE WHEN ZP4_DATAE='' THEN NULL ELSE CONVERT(VARCHAR,CONVERT(DATETIME,D1.ZP4_DATAE),0) END)
AS ZP4_DATAE, D1.ZP4_HORAS, D1.ZP4_HORAE, D1.ZP4_KMINI, D1.ZP4_KMFIN, D1.ZP4_EST, D1.ZP4_CIDADE, D1.ZP4_LOCAL, D1.ZP4_VEIC,
C1.RA_NOME FROM ZP4010 D1 INNER JOIN SRA010 C1 ON D1.ZP4_FUN = C1.RA_MAT AND C1.D_E_L_E_T_='' AND C1.RA_FILIAL='01' WHERE D1.ZP4_FILIAL='01'
AND D1.D_E_L_E_T_='' ORDER BY D1.ZP4_DATAE+ZP4_HORAE DESC
Software version: 3400
Thanks!
New to ADSelfService Plus?