Hi guiys,

I have an erro on execute SQL insert on joget data in table.

Message:

ERROR 03 Sep 2022 21:34:40 org.joget.apps.app.lib.DatabaseUpdateTool - jwc_paulomnasc : Error executing plugin 3022 java.sql.SQLDataException: (conn=73015278) Truncated incorrect datetime value: '03-09-2022 09:34 PM'

SQL command:

insert into app_fd_transacao 

(id

,c_cboCtContabil

, c_cboTipoConta

, c_cboTipoTransacao

, c_id_valor_transacao 

,createdBy

,createdByName

, dateCreated

, dateModified

, modifiedBy

, modifiedByName) 

values 

(0

,'#form.app_fd_pagamento.cboCtContabil#'

, '#form.app_fd_pagamento.cboTipoConta#'

, 'Debito'

, '#form.app_fd_pagamento.idt_Pagamento#'

,'#user.{variable.username}.firstName#'

,'#user.{variable.username}.firstName#'

, STR_TO_DATE('#date.{envVariable.dateFormat}#', '%d-%m-%Y %h:%i')

, STR_TO_DATE('#date.{envVariable.dateFormat}#', '%d-%m-%Y %h:%i')

, '#user.{variable.username}.firstName#', 

'#user.{variable.username}.firstName#');

Thanks,

Paulo Nascimento