Joget DX 8 Stable Released
The stable release for Joget DX 8 is now available, with a focus on UX and Governance.
Hi, according to https://stackoverflow.com/questions/21213561/truncated-incorrect-date-value based on the error message, the datetime format is incorrect so you may need to adjust the format.
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