1
0
-1

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


    CommentAdd your comment...

    1 answer

    1.  
      1
      0
      -1

      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.

        CommentAdd your comment...