SQL & PL/SQL

Hi,

I have a date with this format "19-MAR-13 06.53.57.000000000 PM". I want to make to convert this time to local timezone where the data format should show the same like input.

I am trying with following query :

select from_tz(cast(to_date('19-MAR-13 06.53.57.000000000 PM', 'DD-MON-YYYY HH24:MI') as timestamp),'GMT') at time zone 'JAPAN'
FROM DUAL;

But for some reason it is showing "date format picture " error.

Can someone help me.


Thanks,
Prakash