Question & Answer > View Question

calculate age in sql select query JDBC datalist binder

Confluence User - 06 Nov, 2017

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

datalists

1

Confluence User •

07 Nov, 2017 •

confluenceUser •

•

confluenceUser •

Hi illei

Here are some examples for MySQL:

https://stackoverflow.com/questions/2533890/how-to-get-an-age-from-a-d-o-b-field-in-mysql

1

CSV | Excel | XML | PDF

RELATED QUESTIONS

Can I make list that read the Running Processes ? I want to add my own list and not using the list in monitor

Can I make list that read the Running Processes ? I want to add my own list and not using the list in monitor

How to customize datalist process formatter

Please help me fix the problem. The text field is pulling data from a datalist with more than 50k records and the browser hangs.

Please help me fix the problem. The Pop up select box is pulling data from a datalist with more than 50k records and the browser hangs.

I want to have a visibility control for hyperlink based on the date in a list builder, what type of operator I should use and how?

I Want to Add , Add to Cart functionality like Swiggy or Zomato This is possible in joget?

List Question

Create Folder on the Home Page

Async search list with ajax

1

CSV | Excel | XML | PDF

Your answer

Print