CODEWITHSUNDEEP
phpjquerymysqlmysqlidatepicker
Luke G
Luke G

Reputation: 79

Timestamp and form input date/time

I have not got any code built yet as I need to ask this question before I can start making it.

first what I am doing: I am going to be making a tournament system on my website and I would like the tournament creators to choose a date and time that tournament will be active for signups and closed for signups.

I believe I will be using www.jongsma.org datepicker as I think it is very nice looking and easy to use for the end user. Link:here

The Question:

After sanitizing the input from the forms date/time do I need to specify for it to be converted from the users (Person inserting the time) local time to UTC before I store the data on the database or does it automatically convert the input from there local time to UTC when the data is being written to the database?

I am using MySQLite

Upvotes: 1

Views: 937

Answers (1)

Volkan Ulukut
Volkan Ulukut

Reputation: 4218

MySQL accepts datetime in this format "Y-m-d H:i:s". You can always convert different formatted dates into unix_timestamp with strtotime and turn it into mysql date format with:

$unix_time = strtotime($differentFormattedDate);
date("Y-m-d H:i:s",$unix_time);

Upvotes: 3

Related Questions