Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Remove fractional seconds from timestamp

2931143May 1 2015 — edited May 1 2015

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.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 29 2015
Added on May 1 2015
5 comments
4,461 views