Hi Expert's,
How can i get the below date format with T after date and Z after seconds without manually adding to sql.
I see there is a alter statement which will set nls_date_format to date ending with T and Seconds ending with Z but this is manually altering the the date format.
What i am looking is to achieve through SQL without manually concatenating T and Z something like below.
select to_char(sysdate,'YYYY-MM-DD')||'T'||to_char(sysdate,'HH:MI:SS')||'Z' END from dual;
Thanks,
Shiva