Unable to convert to Timestamp in dataflow

Question

Hi

I am trying to convert to yyyy-MM-dd format using toTimestamp or toDate in dataflow. In the below figure, I am trying to get the yyyy-MM-dd from file_name. Substring works but toTimestamp always gives null values. My sink is Timestamp, so I need to convert to Timestamp

Answer 1

Hello @Krishnamohan Nadimpalli ,
Thanks for the question and using MS Q&A platform.
As we understand the ask here is how to get the string converted to tuimestamp, please do let us know if its not accurate.
I am confident that the you are missing the data format which you are passing as an input .

This expression should work .
In my case filename ='27122022'

toTimestamp(concat(substring($filename,5,4),'/',substring($filename,3,2),'/',substring($filename,0,2)),'yyyy/MM/dd')

If you do not pass the dateformat it does give NULL .

Please do let me if you have any queries.
Thanks
Himanshu

---

• Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
  • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators