1 Topic by StateOne (edited by StateOne 2022-06-06 03:50:15)

  • Registered: 2022-01-26
  • Posts: 56

Topic: mysql datetime (Solved Thanks )

hello friends.. i am inserting system current datetime but got an error...  how to insert

SQLExecute('Insert into MyTable(Col1,Col2,DateTime) Values ("MyData1","MyData2","'+Now+'")');

  • From: Нефтеюганск
  • Registered: 2018-04-11
  • Posts: 1,775

Re: mysql datetime (Solved Thanks )

StateOne wrote:

hello friends.. i am inserting system current datetime but got an error...  how to insert

SQLExecute('Insert into MyTable(Col1,Col2,DateTime) Values ("MyData1","MyData2","'+Now+'")');

SQLExecute('INSERT INTO test(te1,te2,dateTime)VALUES("MyData1","MyData2","'+FormatDateTime('yy-mm-dd : hh:mm:ss',Now)+'")');
  • From: Рідна МАТИ, UKRAINE
  • Registered: 2018-06-02
  • Posts: 894

Re: mysql datetime (Solved Thanks )

SQLExecute('Insert into MyTable(Col1,Col2,DateTime) Values ("MyData1","MyData2",datetime(''now''))');
  • Registered: 2022-01-26
  • Posts: 56

Re: mysql datetime (Solved Thanks )

Thanks Both of you