Question

i need to add 3 hours or after 3 hours (GMT+3) in date( H:i:s ) in my query

$query2="SELECT location FROM course where Dr_ID = 2 AND time_start <=  ".date( H:i:s )."  and time_end >  ".date( H:i:s )." ";

and thanks

Answer 1

You can acheive that by using time() function and then adding the number of seconds to adjust the DateTime variable.

在这种情况下,你想增加3小时,即:

  3 Hours = 60 Seconds X 60 Minutes X 3

因此,time()+(3*60*60)将从事这项工作。

一、导言

    $query2="SELECT location FROM course 
   where Dr_ID = 2 
   AND time_start <=  ".date( H:i:s )."  
   and time_end >  ".date( H:i:s ,time()+(3*60*60))." ";

Answer 2

date(“H-i-s”), mktime(date(H)+3,日期(i),日期(s ),0, 0;

Answer 3

您可尝试<代码>(“h:i:s”、strtotime(+3小时”);。

这有助于你

友情链接