String to TimeStamp along with AM PM

[srds2]

I have String as Input and have to load it to a TimeStamp(6) in Oracle.
My String is like this:3/31/2011 4:05:23.500000 AM

When I Do the following type conversion
String to TimeStamp(Column,'%m/%d/%yyyy %h:%n:%s.6')
The value 3/31/2011 4:05:23.500000 PM is getting loaded into the database.
It should load AM instead of PM

Can any one help me out with this???

I tried this conversion also
String to TimeStamp(Column,'%m/%d/%yyyy %h:%n:%s.6 %aa'). This gave me an error saying invalid timestamp format.

[BI-RMA]

So, what was the solution to solve this?

[srds2]

just used the below conversion String to TimeStamp(Column,'%m/%d/%yyyy %h:%n:%s.6 %aa')

[chulett]

I tried this conversion also String to TimeStamp(Column,'%m/%d/%yyyy %h:%n:%s.6 %aa'). This gave me an error saying invalid timestamp format.

So not so invalid after all?