Timestamp Issue

Ask the Community
1

Hi!

I’m trying to get my time strings, ie “9:17:54 AM”, to timestamps. My transform is currently:

“ Completion_Time = Cast to Timestamp(

String: Completion_Time,

Time zone: America/New_York,

Formats: [

“hh:mm:ss a”

])”

I am receiving null in my output column. Any ideas as to why? AIP also could not generate a recommended output. To give you a background on my data, I locally had it stored as an XLSX and converted to CSV, and then I added it to my Foundry Pipeline Builder.

Thanks for the help,

Noa

2

Hey Noa,

This is because the 9 has only one digit, whereas the ‘hh’ pattern expects exactly 2, so something like 09 would work. You can replace the format string with ‘h:mm:ss a’ and I think it should work, a single h works with either 1 or 2 digits.