cannont use select distinct(substring(convert))

a2ps · **Joined:** Mon Oct 01, 2007 6:23 am **Posts:** 20

helloo and happy new year for all!

Im using SQL server database, hiebrnate 3.2

when I send the request below, hibernate truncate a part of sql

Code:

String sql  = "select distinct (substring( (convert(varchar,date,120) ),1,10)) from Table order by date""
List results = getHibernateTemplate().find("sql");

the sql shown by hibernate :

Code:

select
        distinct substring(convert(varchar,
        table0_.Date,
        120)) as col_0_0_ 
    from
        Table table0_ 
    order by
        table0_.Date

regards!

gonzao_diaz · **Joined:** Mon Nov 26, 2007 2:29 pm **Posts:** 443

Probably Hibernate itself doesn't support the "convert" function, and all those commas inside it are confusing the SQL parser.