Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
1.3k views
in Technique[技术] by (71.8m points)

sql - Date/time comparison

I want to find the date/time with minimum date/time between records. In a table with multiple records.

Fx.

 - 11/11-15 13:00
 - 11/11-15 15:30
 - 11/11-15 16:45 <= (find this record)
 - Timenow (11/11-15 18:33) the current record i want to create but i need to compare the old dates with.

I can't create the logic, help !

Thanks

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)

You can create a function that returns the difference between two dates, run all the possible dates through this function, then pick the lowest difference.

Something like this (pseudo c code)

 int array[numdates];
 for (int i=0;i<numdates;i++)
     array[i]=compareDates(date[index], currentDate);

Then you can sort the array so the lowest number is at the beginning (or end) and return that one.


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

2.1m questions

2.1m answers

60 comments

57.0k users

...