Formatting a datetime referring to a 24-hours clock

pmscorca 1,007

Hi,

in an ADF pipeline I'm trying to use this expression:

@formatDateTime(utcNow(),'yyyy-MM-ddTHH:mm:ss')

but this return a value that shows the AM/PM indicator.

I'd like to show the time referring to the 24-hours clock.

Any suggests to me, please? Thanks

Deleted

This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
pmscorca 1,007 Reputation points

2024-06-29T12:28:19.98+00:00

Hi, the formatDateTime function accepts only two arguments.
Jack Jokky 0 Reputation points

2024-07-05T08:42:49.5066667+00:00

Hello, Display the time in a 24-hour format without the AM/PM indicator in an Azure Data Factory (ADF) pipeline, you should use the uppercase ‘HH’ in your format string. The ‘HH’ specifier represents the hour in a 24-hour clock. Publix Passport

1 answer

AnnuKumari-MSFT 33,151 Reputation points Microsoft Employee

2024-07-01T10:31:57.8866667+00:00

Hi pmscorca ,

Thankyou for posting your query on Microsoft Q&A platform .

I understand from your query that you want to fetch the current time and display in 24-hour clock format without the AM/PM indicator.

The formatDateTime function in Azure Data Factory (ADF) can be used to format the current date and time in a specific format.

The format for a 24-hour clock time is HH:mm:ss.

Ensure you use HH for hours in 24-hour format (from 00 to 23) instead of hh, which is for hours in 12-hour format (from 01 to 12).

The expression which you are using is correct and should be giving the output in 24-hour format. I tried to reproduce the same and got the expected result.

Case1: Using HH for hours

Case2: Using hh for hours

Hope it helps. Please let us know if you have further questions.

Kindly mark the answer as accepted if it helped. Thankyou
Please sign in to rate this answer.
pmscorca 1,007 Reputation points

2024-07-01T14:28:06.0966667+00:00

Hi, as written in my first post for the formatDateTime function I've already specified "HH" in uppercase.

Viewing the input information of the related Fabric data pipeline I can see this:

but in the Fabric lakehouse I can see this:

AnnuKumari-MSFT 33,151 Reputation points Microsoft Employee

2024-07-02T05:58:53.1166667+00:00

pmscorca ,

Since the issue is with Fabric data pipeline , I would recommend you to raise the concern on Fabric community platform instead: https://community.fabric.microsoft.com/t5/Data-Pipelines/bd-p/df_pipelines so that right engineer can engage and raise bug with the internal team.

Additionally, ADF doesn't have this issue as I have tried the scenario in ADF pipeline. Kindly accept the answer by clicking on Accept answer button. Thankyou

pmscorca 1,007 Reputation points

2024-07-02T10:08:19.6433333+00:00

Hi @AnnuKumari-MSFT this issue could be specific for a Fabric data pipeline or not. Fabric Data Factory and Azure Data Factory are more similar.

Also in a Fabric data pipeline the input json show the right datetime.

Are you sure that Azure Data factory writes the right datetime? You have showed me the calculated datetime as visible from the json code not as saved in a table.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Formatting a datetime referring to a 24-hours clock

1 answer

Your answer