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.
String to TimeStamp along with AM PM
Moderators: chulett, rschirm, roy
Re: String to TimeStamp along with AM PM
So not so invalid after all?srds2 wrote: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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers