Specifying time in a SQL query with PHP

Question

I want to have a button where the user inputs the date In the format, e.g. 22 Dec 2010 07:55 AM. But it would be great if it was in the format just 22 Dec 2010 It should be converted to time in this format 1292984705 while trying to process it in a mysql query.

mysql_query("SELECT * FROM order_history where date>'$time1' AND date<'$time2' ORDER By id DESC");

Jacob Relkin · Accepted Answer · 2010-12-22 04:30:31Z

3

Use the strtotime() function to convert the string representation of a date into a UNIX timestamp:

mysql_query("SELECT * FROM order_history where date > " . strtotime($time1) . " AND date < " . strtotime($time2) . " ORDER By id DESC");

Notice that I removed the quotes surrounding the concatenated timestamps, this will perform true arithmetic on the timestamps.

edited Dec 22, 2010 at 4:30

answered Dec 22, 2010 at 4:24

Jacob Relkin

163k34 gold badges352 silver badges321 bronze badges

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

Collectives™ on Stack Overflow

Specifying time in a SQL query with PHP

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related