Level 73
I really suggest you store both values in the same column, because this design is bad. How ever you should be able to do
date(now()), time(now())
1 like
Sep 3, 2022
4
Level 1
Mysql Seperated Date and Time Columns
We have a times table with below structure:
create table times
(
id bigint unsigned primary key,
user_id bigint unsigned not null,
day date not null,
time time not null
)
collate = utf8mb4_unicode_ci;
create index on times (day);
create index times_time_index on times (time);
day sample is '2022-09-18' and time sample is '13:10:00'
What is best query for selecting times > now()?
Level 102
Or (assuming only on that date)
->where('day', now()->toDateString())->where('time', '>', now()->toTimeString())->get()
1 like
Level 122
If you want to get records where the date date/time is in the future;
Date needs to be today AND time needs to be later
OR
Date needs to be after today and time can be anything
->where(function($query){
$query->where('day', today())->where('time', '>', now()->format('H:i:s')
})
->orWhere('day', '>', today())
->get()
1 like
Level 1
@Snapey nice Man, This is realy I want thanks a lot
Please or to participate in this conversation.