Converting text to date or number

[igfortun]

Hi all, 
I am trying to create a new data item that converts text such as: "10:45:00 AM" to either a true date format, or numeric format. 
Thank you so much in advance,

[oscarca]

Hello,
Below statement will cast String to Time format:

cast('10:45:00' as time)

//Oscar

[igfortun]

But my data field has the words "AM" and "PM"

[oscarca]

It should work anyways cast('10:45:00 AM' as time)