Вопросы Теги

SQL запрос, чтобы получить контент старше 3 недель

Функция: 

public float simpleSimilarity(String u, String v) {
    String[] a = u.split(" ");
    String[] b = v.split(" ");

    long correct = 0;
    int minLen = Math.min(a.length, b.length);

    for (int i = 0; i < minLen; i++) {
        String aa = a[i];
        String bb = b[i];
        int minWordLength = Math.min(aa.length(), bb.length());

        for (int j = 0; j < minWordLength; j++) {
            if (aa.charAt(j) == bb.charAt(j)) {
                correct++;
            }
        }
    }

    return (float) (((double) correct) / Math.max(u.length(), v.length()));
}

Тест: 

String a = "This is the first string.";

String b = "this is not 1st string!";

// for exact string comparison, use .equals

boolean exact = a.equals(b);

// For similarity check, there are libraries for this
// Here I'll try a simple example I wrote

float similarity = simple_similarity(a,b);
13
задан OMG Ponies 20 October 2009 в 00:44
поделиться

3 ответа

How about:

select contentID, title, created 
from content
where created < dateadd(week,-3,getdate());

This sticks closer to the question. 21 days is fine, obviously means the same, but I find that it's good to use the terminology used in the question.

For example... a while back I was asked to survey an average of 1 in 50 visitors to a site. I described this as a proportion of 0.02, and the client wasn't happy. I pointed out to the client that they're the same, but I learned my lesson, and now if I change the way that something is described, I make sure I comment to that effect, and preferably don't change it in the first place. If the client wants 3 weeks, do it as 3 weeks, not 21 days.

47
ответ дан 1 December 2019 в 17:40
поделиться

в MS SQl 2000/2005 вы можете сделать это 

Select
   contactID,
   title,
   created
from
   content
where
   created < getdate()-21
3
ответ дан 1 December 2019 в 17:40
поделиться

Попробуйте следующее: 

select contentID, title, created from content
where created < dateadd(day,-21,getdate())
0
ответ дан 1 December 2019 в 17:40
поделиться