Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
HamidBee
Power Participant
Power Participant

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.

 

HamidBee_0-1702509332437.png

 

 

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!

1 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.

vnikhilanmsft_2-1702553544162.png


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.

View solution in original post

5 REPLIES 5
HamidBee
Power Participant
Power Participant

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

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.

vnikhilanmsft_2-1702553544162.png


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
Community Support
Community Support

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.

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.

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

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

November Update

Fabric Monthly Update - November 2024

Check out the November 2024 Fabric update to learn about new features.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.