06-12-2012 05:15 PM
I am trying to format a max query for the date. My code is:
create table lib.market as
max(eff_dt) as eff_dt
group by id);
The table has in it:
It returns the following:
How do I make it appear with the dates. I am sure it is some format but not sure.
06-12-2012 05:33 PM
hi ... fyi ...
1/ you can get rid of the parentheses
2/ SQL ends with a QUIT
3/ you are grouping by ID so you can get rid of DISTINCT
create table want as
select id, max(eff_dt) as eff_dt format=mmddyy10.
group by id;
Need further help from the community? Please ask a new question.