I have a SELECT statement which looks (in part) like the following and I am looking for the QB equivalent:
- Code: Select all
SELECT\
STRING(DATEFORMAT(MIN(pStart.from_date), 'yyyy-mm-dd' )),\
I tried following but although i gives no error it does not seem to be correct.
- Code: Select all
query.result
.add(query.functions.cast((pStart.from_date.min), 'yyyy-mm-dd'), QUERY_COLUMN_TYPES.TYPE_STRING)
Any hint how the QB equivalent might look like?
Thanks and regards,