Need Help with Formatting DateTime in Azure Synapse Data Flow Expression Language

[HamidBee]

Hi All, 

I'm working with Azure Synapse Analytics and I'm facing an issue with the Data Flow expression builder. My goal is to format a column named "Start Date (BST)" which currently has the format yyyy-MM-ddTHH:mm:ss.SSSSSS to dd/MM/yyyy HH:mm:ss, effectively removing the milliseconds.

Here's what the date looks like right now:

2022-07-07T23:43:13.722007

I tried using the following expression in the data flow expression builder:

toTimestamp('Start Date (BST)', 'dd/MM/yyyy HH:mm:ss:SS')

However, I am getting an error stating "Unable to parse the expression. Please make sure it is valid."

Could someone please guide me on the correct syntax or the steps I should take to format the datetime values properly using the expression builder in Azure Synapse? I would appreciate any insights or examples of the correct expression to achieve this.

Thank you in advance!

[HamidBee]

But why does is the forum under "Get Help With Synapse"?

[v-nikhilan-msft · Accepted solution]

Hi @HamidBee 

Microsoft Fabric is an all-in-one analytics solution for enterprises that covers everything from data movement to data science, Real-Time Analytics, and business intelligence. It offers a comprehensive suite of services, including data lake, data engineering, and data integration, all in one place.

With Fabric, you don't need to piece together different services from multiple vendors. Instead, you can enjoy a highly integrated, end-to-end, and easy-to-use product that is designed to simplify your analytics needs.

Please refer to this document for more information: Link1

So if you have any query related to Synapse Engineering in Fabric , then you can post a question in Get Help with Synapse Forum. But your ask is related to Azure Synapse Analytics. So you need to ask the question in a different forum Ask a question - Microsoft Q&A.

Thanks.

[v-nikhilan-msft]

Hi @HamidBee 
Thanks for using Fabric Community.
The ask in the above post is related to Azure Synapse. It appears that the ask is not supported at this time. We request you to please log the ask here Ask a question - Microsoft Q&A. Microsoft Q&A platform can help you better.

[HamidBee]

Hi. Can you please explain to me why it is not supported here at this time. I thought this is in Azure Synapse forum? or am I wrong?. Thanks.

[v-nikhilan-msft]

Hi @HamidBee 
This is Microsoft Fabric Community. For Azure Synapse related queries please use Ask a question - Microsoft Q&A.
Thanks.