Insert Statement

Question

Hi
MySqlCommand myCommand = new MySqlCommand("Insert into attendance (attendance_id,employee_id,punchin_time) values(" + 10 + "," + empno + "," + "Now()"  + ")", con);
myCommand.ExecuteNonQuery();
IT is working fine . DateTime is correctly stored in Database . I want to know whether this will store Server Date&Time or Client Machine . I want Server Date&Time.
Thanks

Prabhu Raja · Accepted Answer

Hi Jagjit,
You doesn't mention which database you're using. I think you using MySql Database.
For MySql Database your Select Query (now() function) Will Store Server Date and time, or if you're using Sql Server Database ,then use GetDate() funtion .

Narayan · Answer

It will take the database server time. You can very well use GetDate() function aswell.