I have a requirement , something like this :
In our parallel job, we need to read a source file , one of the fields of which contain data like :
08/24/2012 23:11:15
What we intend is to transform it to a format like :
2012-08-24 11:11:15 PM
I was looking ahead to use the OCONV function(as because I want to display the AM/PM portions also , which calls in for a tranformation that can yield data as per a custom external format) to acheive this , but seriuosly , no idea at all about the arguments of the fucntion.
Any help is truly appreciated.
Regards
Kumarjit.
Playing with Date-type data
Moderators: chulett, rschirm, roy
Playing with Date-type data
Pain is the best teacher, but very few attend his class..
Clarify for us the data type of the target - is it specifically a Timestamp or is it another string? For the latter use TimestampToString after the initial conversion and use '%(HH,u)' to get it back to a string with the time in 12 hour format with an upper case AM/PM.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers