While executing the below query I am getting the output with fractional seconds
select to_timestamp_tz(systimestamp,'DD-MM-YY HH12:MI:SS.FF AM TZH:TZM') from dual;
Output :
01-MAY-15 02.54.55.364000000 PM +05:30
I want the output without fractional seconds like :
01-MAY-15 02:56:21 PM +05:30
Could you please suggest how can I get the output without fractional seconds.
I can not change the NLS settings.
Thanks.