SQL get nearest date record, MySQL

SQL get nearest date record

Language: Layout:


absolute service time: 0,32 sec

edit mode | history

  
Booking_id
Name
start_date
DATEDIFF(start_date, NOW())

1
6
jkf
18.07.2017 00:00:00
-31

2
1
abc
01.01.2018 00:00:00
136

3
3
pqr
16.01.2018 00:00:00
151

4
2
efg
05.02.2018 00:00:00
171

5
4
xyz
19.02.2018 00:00:00
185

6
5
jkl
18.01.2017 00:00:00
-212

λ

                                      .NET NoSQL database for rapid development