storing Time and Dates into an SQL database using php [closed]

Question

Closed. This question needs to be more focused. It is not currently accepting answers.

Want to improve this question? Guide the asker to update the question so it focuses on a single, specific problem. Narrowing the question will help others answer the question concisely. You may edit the question if you feel you can improve it yourself. If edited, the question will be reviewed and might be reopened.

Closed 11 years ago.

Improve this question

How do I store dates and time from an online form I have into an SQL database using PHP? The date/time function is working quite ok.

Question is too broad . Have you googled before coming here ? — Shankar Narayana Damodaran
– Shankar Narayana Damodaran, Commented Nov 21, 2013 at 8:15
Ansers to this question to stackoverflow will be helpfull.[enter link description here][1] [1]: stackoverflow.com/questions/13671185/… — Lakmal Vithanage
– Lakmal Vithanage, Commented Nov 21, 2013 at 8:16

Siraj Khan · Accepted Answer · 2013-11-21 08:18:05Z

0

You should use the datetime datatype for your requirement. It will store both the date and time from your input field based on your query.

For retrieving the datetime you can use the mysql's date_format() function or PHP's date() function. The datetime will always be stored according to the server's time and not on the clients time.

answered Nov 21, 2013 at 8:18

Siraj Khan

2,35818 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Siraj Khan Over a year ago

normally we use the PHP date function and that way if you ever want to store the time relative to the user's timezone you can simply change the timezone based off the user's settings. When you pull it out of the database, use strtotime() to convert it, then you can use all the date() features to display it however you want. Example: echo date('F j, Y',strtotime($db_datetime));

Collectives™ on Stack Overflow

storing Time and Dates into an SQL database using php [closed]

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related