calculate age in sql select query JDBC datalist binder

 
1
0
-1

how to calculate age in sql select query in JDBC datalist binder . Is it possible? It keep pop up error retrieve column whe i add below query.

select convert(int,DATEDIFF(d, '1993-10-31', getdate())/365.25) AS Age
    CommentAdd your comment...

    1 answer

    1.  
      1
      0
      -1