Insert timestamp type into firebird database

Navigation
0

Error in insert in firebird database, field DataCadastro type timestamp does not accept string . 

INSERT INTO VENDA(CODIGO, NRO_VENDA, DATA_VENDA, VALOR_TOTAL_PRODUTOS, VALOR_ACRESCIMO,
VALOR_DESCONTO, VALOR_TOTAL_VENDA, CODIGO_CLIENTE)
VALUES (1, 1, '14/12/2016', 5, 2, 3, 2, 1)
  Overflow occurred during data type conversion.

    
asked by anonymous 03.01.2017 / 16:31

1 answer

1

Try to replace the date of '14/12/2016' with '12/14/2016'

The date in firebird follows the following format: MM/DD/YYYY .

    
03.01.2017 / 16:36
Separate or not the backend frontend? [closed] Accept cents in a javascript code