DATEADD in JDBC template

[Gerard Geded]

I'm trying a query select with jdbc and spring boot,

I want select informations where my creation date value is LESS than now minus 30.

I tried like this :

"SELECT *  FROM informations WHERE
               lastTreatment < DATEADD(MINUTE, -30, GETDATE())"

I have an error like this :

Caused by: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar

Anyone has idea ? Thanks

[Campbell Ritchie]

Don't know. What happens when you run that query from the command line/terminal?
Moving to our databases and Spring fora.

[Gerard Geded]

Campbell Ritchie wrote:Don't know. What happens when you run that query from the command line/terminal?
Moving to our databases and Spring fora.

In SQL Console that's work, but in my java code no...

[Ron McLeod]

Gerard Geded wrote:I tried like this :

"SELECT *  FROM informations WHERE
               lastTreatment < DATEADD(MINUTE, -30, GETDATE())"

Can you show the actual code where this is used?

[Gerard Geded]

Ron McLeod wrote:

Gerard Geded wrote:I tried like this :

"SELECT *  FROM informations WHERE
               lastTreatment < DATEADD(MINUTE, -30, GETDATE())"

Can you show the actual code where this is used?

This code works with console SQL :

protected List<Information> selectInfo() {

        List<Information> info= jdbcTemplate.query(
                "SELECT *  FROM information" +
                    "WHERE AND lastTreatment < NOW() - INTERVAL 30 MINUTE ", 
                  
                (rs, rowNum) ->
                        new Information(
                                rs.getTimestamp("lastTreatment"),
                               
                        ));


        return info;
    }

[Ron McLeod]

The concatenated string will be:"SELECT *  FROM informationWHERE AND lastTreatment < NOW() - INTERVAL 30 MINUTE "with no space between information and WHERE

[Gerard Geded]

Ron McLeod wrote:The concatenated string will be:"SELECT *  FROM informationWHERE AND lastTreatment < NOW() - INTERVAL 30 MINUTE "with no space between information and WHERE

No looks my screenshot, this part it's OK, the problem is with the DATE but i don't know what exactly

[Ron McLeod]

This:"SELECT *  FROM information" +                    "WHERE AND lastTreatment < NOW() - INTERVAL 30 MINUTE "
and this:


are obviously not the same.  One has a table name of information, the other has UsersAccount.

[Gerard Geded]

Ron McLeod wrote:This:"SELECT *  FROM information" +                    "WHERE AND lastTreatment < NOW() - INTERVAL 30 MINUTE "
and this:


are obviously not the same.  One has a table name of information, the other has UsersAccount.

Considered the last screenshot it's good, sorry for the confuse

[Himai Minh]

I notice this lastTreatment =< Now() - INTERVAL 30 MINUTE.
Should it be lastTreatment < NOW() - INTERVAL 30 MINUTE ?

[Campbell Ritchie]

Also, now you come to mention it, should there be a space between the = and < characters? That doesn't look right.

[Ron McLeod]

Is =< a valid comparison operator?  Shouldn't it be <= ?