Treehouse: Grow your CSS skills. Land your dream job.

mysql/php – date and time

  • # June 1, 2012 at 11:15 am


    I have two different fields, date and time, saved in MySQL database and I need to compare those two together with the current time in PHP.

    I googled but I can only find examples with datetime or timestamp, nothing with “date” and “time” types.

    Can you help me please?

    # June 1, 2012 at 1:32 pm

    are your date and time fields DATE and TIME types, respectively?

    Also, what do you mean by “current time”? Is your script (_and_ database, _and_ client) using UTC?

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.