hello guys,
how can i select from table with a given time then select the nearest time available
sample select * from mytable where Time=10:00, i want to get the nearest time
ID | Time
1 09:00
2 13:00
3 15:00
royaloba 0 Junior Poster in Training
debasisdas 580 Posting Genius Featured Poster
royaloba 0 Junior Poster in Training
debasisdas 580 Posting Genius Featured Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.