SQL & PL/SQL

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!

format code appears twice error is getting

728995Oct 28 2009 — edited Oct 28 2009

Hi All,

I am getting the error as "formar code appears twice" while running the following Query.

select to_timestamp(sysdate-4||'10:00 AM','DD/MM/YYYYHH:MM AM') from dwh.dim_time

Requirement is :- No.of Rollback days is coming.so first i need to rollback the no.of days with system date after that i need to append time and hour AM Pm(these are coming from Different String).

Could any one please help to me.

Thanks and Regards
Swetha.

This post has been answered by 21205 on Oct 28 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 25 2009

Added on Oct 28 2009

4 comments

603 views