Create a table called "Cheater", containing both PatientId and last updatetime. Set both from a trigger on the Patient-table - do an insert of it doesn't contain the patient-Id, otherwise simply update the time.
Index the table on time, id.
You now have an indexed int/date table for your lookup.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
I created a table in ms access, and then i wanted to connect it to a java gui front end using type 1 driver. so i tried to create an odbc dsn for access. the test for connection failed while creating the dsn itself. Any suggestions will be extremely helpful, thanks.
When there is case for writing a many number of mysql command line in VB.NET programming to how to write the module or dll file to handle easily all the command .Please suggest other weblinks or code project article in this discussion. If there is any further idea also add to this discussion. Online Mysql with VB.Net
When you store date/time AS date/time in database you store some binary (like milliseconds since 1st of January 1970). Database do nothing and care less about the representation of that date/time. You have to look into the code to see where the problem (you may have locals with 12 hours).
If you store date/time as string - you do a big mistake!!!
I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)