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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
HamidBee
Impactful Individual
Impactful Individual

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
Impactful Individual
Impactful Individual

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayFBCUpdateCarousel

Fabric Monthly Update - May 2024

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

Top Solution Authors