- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Need Help with Formatting DateTime in Azure Synapse Data Flow Expression Language
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!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
But why does is the forum under "Get Help With Synapse"?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @HamidBee
This is Microsoft Fabric Community. For Azure Synapse related queries please use Ask a question - Microsoft Q&A.
Thanks.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
10-13-2024 07:14 AM | |||
09-05-2023 11:17 AM | |||
08-19-2024 11:57 PM | |||
07-29-2024 02:45 AM | |||
10-07-2024 01:25 AM |
User | Count |
---|---|
3 | |
2 | |
1 | |
1 |