 |  |  |  |  |  |  |  |
query nearest time
 |
•
•
Join Date: Sep 2006
Posts: 54
Reputation: 
Solved Threads: 1
Junior Poster in Training
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
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
What do you mean by nearest .
What is the parameter of nearest
1 min
30 min
1 hr
2 hr
.....
....
What you want ?
What is the parameter of nearest
1 min
30 min
1 hr
2 hr
.....
....
What you want ?
Share your Knowledge.
•
•
Join Date: Sep 2006
Posts: 54
Reputation:
Solved Threads: 1
Junior Poster in Training
•
•
•
•
Originally Posted by debasisdas 
What do you mean by nearest .
What is the parameter of nearest
1 min
30 min
1 hr
2 hr
.....
....
What you want ?
ID TIME
1 08:00
2 09:00
3 11:00
4 14:00
5 15:00
when i query from this table, i want to find the nearest or closest time to my given time
sample select * from mytable where mytime 08:30 then get the closest time available
|
Similar Threads
- mysql DELETE not working (PHP)
- PHP or ASP (Search Engine Optimization)
- Login Security ! (PHP)
- Need help to display data with image into page (ASP.NET)
- query optimization (PHP)
- Users management (PHP)
- Querying within the results of a previous query? (MySQL)
- Advanced mySQL Querys (PHP)
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: Visual Basic
- Next Thread: Compile Error
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest Visual Basic 4 / 5 / 6 Posts
- Today's Posts
- Unanswered Threads
* 6 429 2007 access activex add age application basic beginner birth bmp calculator cd cells.find click client code college component connection connectionproblemusingvb6usingoledb copy creat ctrl+f data database datareport date delete dissertations dissertationthesis dissertationtopic edit error excel excelmacro file filename form hardware header iamthwee image inboxinvb internetfiledownload keypress label listbox listview liveperson login looping machine microsoft movingranges number objectinsert open oracle password prime program prompt range-objects readfile reading record refresh remotesqlserverdatabase report save search sendbyte sites sort sql sql2008 sqlserver subroutine tags textbox time urldownloadtofile vb vb6 vb6.0 vba visual visualbasic visualbasic6 web window windows
