Posts by Teixeira • 21 points

• 0

  votes

  0

  answers

  125

  views

  Q: Field Date register date

  I have a table that one of the fields is date type. On my page insert.Asp when I type the date for example so 10/07/2017 or 2017-07-12 not saved in Mysql database. The error that is shown is this:…

  mysql asp date

  asked 7 years, 4 months ago Teixeira 21

• 0

  votes

  0

  answers

  43

  views

  Q: HTML form does not work in Data Change

  The "Insert" and "delete" forms are interacting with the Mysql database table data. Except The record-manager form that has the function of "Change" record: <%@LANGUAGE="VBSCRIPT"…

  mysql asp

  asked 7 years, 9 months ago Teixeira 21

• 1

  votes

  1

  answer

  5997

  views

  Q: Currency format

  To be complete I could not enter a FORMAT(Value,2) including in CONCAT? SELECT * , CONCAT('de ', Valor, ' por ', desconto) AS promocao FROM (SELECT Valor, Valor - Valor * 20/100 AS desconto FROM…

  mysql sql

  asked 7 years, 11 months ago Teixeira 21

• 1

  votes

  1

  answer

  67

  views

  Q: CONCAT not working

  SELECT indicativo_ja_registrado, qra, fez_contato, DATE_FORMAT(data_qso, '%d/%m/%y') AS data_qso, DATE_FORMAT(data_agora, '%d/%m/%Y') AS data_agora, TIMESTAMPDIFF(YEAR, data_qso, data_agora) AS…

  mysql

  asked 7 years, 11 months ago Teixeira 21