Autofill datetime in date field

This topic is locked

Autofill datetime in date field	1/28/2015 12:36:49 AM
PHPRunner General questions
G GunnySJB author Hello i have a table form a SQL server that i connected to my project in MYSQL. Everything works fine. But the field in the SQL table is a datetime and i have to use it to autofill a field in my MYSQL table with a lookup in a add page. I have tried to put DATE(xxx) in the query of the SQL table, but this is not recognized in PHPRunner. So what option do i have ?


	Sergey Kornilov admin 1/28/2015
	It's not easy to understand what and how you autofill but correct database date formats are yyyy-mm-dd and yyyy-mm-dd hh:mm:ss. Make sure that the value you trying to insert is in one of those formats.