PI Table Dataset Date Formatting

Discussion created by priyanka.tayade on Jul 8, 2014
Latest reply on Jul 15, 2014 by Gregor

I need to cast timestamp in the to_char(timestamp, 'mm/dd/yyyy hh:mm AM') format. While creating dataset in PI Data Services, I am getting error because :mm is parsed as string. Is there any another way to parse timestamp in this format?