All Questions
3 questions
-3
votes
2
answers
820
views
how to add 30 min to date values in sql so they change correctly?
there is a timepair table. It has columns :
start_pair end_pair
08:30:00 09:15:00
I need to shift it by 30 min - how to do it? 8:30 becomes 9:00.
update
set start_pair = date(start_pair) + minute(...
- 24.4k
0
votes
1
answer
167
views
Showing a row for every minute based on start and end time
I have a table that looks like below:
task_id start_date end_date
t1 2020-05-01 8:00:00 2020-05-01 9:45:00
t2 2020-05-01 8:30:00 2020-05-01 9:00:00
...
-1
votes
1
answer
181
views
Get Birthday data date wise [duplicate]
I have a dob(DATE) field in table which stores birth dates of users. now i have query to get users who have birth date in this month is as follow
SELECT * FROM register WHERE MONTH(dob) = MONTH(NOW())...
user9341437