How to get number of hours left from database time in Codeigniter

Asked Jun 30 '20 at 09:41

Active Jun 30 '20 at 09:41

Viewed 422 times

I Have following structure in my database :

id    |   date   |   time
(int)  (varchar)   (varchar)

is storing date & time like this :

date          time 
2020-07-04  06:15:00

Now i want to get those record whose current date & time is less than 2 hours, so i'm getting all records using normal select and

$current_time = date("Y-m-d h:i:s"); 
$datetime1 = new DateTime();
$datetime2 = new DateTime($row->date.' '.$row->time);
$interval = $datetime1->diff($datetime2);
$elapsed = $interval->format('%h hours');

but here what i'm getting is, if my database time has passed then also hours contains value, so if i want to get records which have 2 hours left when comparing the current time then after current datetime has passes then also i will get those rows but i don't want those rows whose time has passed.

asked Jun 30 '20 at 09:41

user3653474

3,393
6
49
135

can you please explain again what you what? i can't understand the last paragraph at all – Alberto Sinigaglia Jun 30 '20 at 09:47
@Berto99: I want to get all rows where difference in date time column and current time is less that 2 hours – user3653474 Jun 30 '20 at 09:50
do you have any models or i can give you a SQL query? – Alberto Sinigaglia Jun 30 '20 at 09:52
i'm using model $this->db->select('*')->from('tablename')->get()->result(); – user3653474 Jun 30 '20 at 09:53
try adding `where datediff(hh, concat(date, ' ', time), getdate()) >= 2` to the query – Alberto Sinigaglia Jun 30 '20 at 09:58
@Berto99 : I have used this query but when i print using $this->db->last_query() it returs nothing removing this part query start working, where(datediff('hh', concat('date',' ','start_time'), getdate())>= 2) – user3653474 Jun 30 '20 at 10:07

How to get number of hours left from database time in Codeigniter

0 Answers0