Insert type timestamp into Firebird database

Asked

Viewed 1,293 times

1

Error in the insert in Firebird database, field DataCadastro type timestamp unaccepted 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.

firebird timestamp

  • The date format shall be MM/DD/YYYY

  • Thank you, it worked perfectly.

1 answer

2


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

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

Browser other questions tagged firebird timestamp

You are not signed in. Login or sign up in order to post.