How do I change the format of SQL output - Informix
Posted on 2011-10-18
This is a two-parter:
I have a query and I am using NVL to grab an integer but it is bringing the result back as 1.0000000000 or 2.0000000000 when it is just in the db as a 1 or a 2.
The 2nd part is I am grabbing dates as YYYY-MM-DD, I need to change the output to their preferred format of mm/dd/yyyy
Here is the query:
select i.id, e.grad_date, p.sex, a.common_app_id, i.firstname, i.lastname, i.middlename, NVL(v.score,'') as score
from id_rec i
join adm_rec a on i.id = a.id
join profile_rec p on i.id = p.id
join ed_rec e on e.id = i.id and e.prim_sch = 1
left outer join intvwrecom_rec v on i.id = v.id and v.intvwrecom = 'INT1'
where a.plan_enr_yr = '2011'
Sample of the output I need changed:
What I want to see: