How to get 24 hours time in format yyyy-m format-dd hh:mm:ss

Question

How to get 24 hours time in format yyyy-m format-dd hh:mm:ss

Tony Johansson 40

Hello, When I file is dropped the ADF is run and this expression @concat(replace(item().name,'.xml',''),' ',formatDateTime(addHours(pipeline().TriggerTime,2),'yyyy-MM-dd hh:mm:ss'),'.json') is assigned to the file that was dropped and to a column in the database.
I need to have the same timestamp added to the file. As it is now if the file is dropped at 2023-04-20 15:13:10 I get from the expression 2023-04-20 03:13:10. I need to have 24 hours format. So as it is now I can't see if the file was dropped in the middle of the night or in the middle of the day. I was pretty sure that my expression should return is 24 hours format but I was wrong. I can't use utcNow becuse I would most certain get two different timestamp appended to the filename. Many thanks in advance

Vinodh247 34,661 Reputation points MVP Volunteer Moderator

2023-04-21T15:08:29.9766667+00:00

Hi, You can try 'tt' for AM/PM designator similar to below. formatDateTime(addHours(pipeline().TriggerTime,2),'yyyy-MM-dd hh:mm:ss tt'),'.json') Or do you have any specific reason to have it only in a 24hrs format?
KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator

2023-04-27T00:35:27.76+00:00

@Tony Johansson Just checking in to see if the below information was helpful. If it answers your query, please do click Accept Answer and Yes for "was this answer helpful", as it might be beneficial to other community members reading this thread. If you have any further query, do let us know.

Thank you
KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator

2023-04-29T01:34:41.15+00:00

@Tony Johansson We still have not heard back from you. Just wanted to check if the below information was helpful? If it answers your query, please do click Accept Answer and Yes for "was this answer helpful", as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

Thank you

2 answers

Your answer

Vinodh247 34,661 Reputation points MVP Volunteer Moderator

2023-04-21T15:08:29.9766667+00:00

Hi, You can try 'tt' for AM/PM designator similar to below. formatDateTime(addHours(pipeline().TriggerTime,2),'yyyy-MM-dd hh:mm:ss tt'),'.json') Or do you have any specific reason to have it only in a 24hrs format?
KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator

2023-04-27T00:35:27.76+00:00

@Tony Johansson Just checking in to see if the below information was helpful. If it answers your query, please do click Accept Answer and Yes for "was this answer helpful", as it might be beneficial to other community members reading this thread. If you have any further query, do let us know.

Thank you
KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator

2023-04-29T01:34:41.15+00:00

@Tony Johansson We still have not heard back from you. Just wanted to check if the below information was helpful? If it answers your query, please do click Accept Answer and Yes for "was this answer helpful", as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

Thank you

Answer 1

Deleted

This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

Comments have been turned off. Learn more

Answer 2

Hi @Tony Johansson , Welcome to Microsoft Q&A forum and thanks for reaching out here. If you would like to have your timestamp in 24 hr format, then specify the format as HH and if you would like to have the timestamp as 12 hr format then use hh. In addition as @Vinodh247 , called out you can use tt to represent AM/PM. Below are some samples.
24 hour format specifier: @formatDateTime(convertFromUtc(utcnow(), 'Pacific Standard Time'), 'yyyy/MM/dd HH:mm:ss tt') The output for the above expression will be : 2023/04/25 15:37:48 PM 12 hour format specifier: @formatDateTime(convertFromUtc(utcnow(), 'Pacific Standard Time'), 'yyyy/MM/dd hh:mm:ss tt') The output for above expression will be: 2023/04/25 03:37:48 PM Here is a sample pipeline payload which I used for testing. Feel free to use it for your testing.

{
    "name": "pipeline13",
    "properties": {
        "activities": [
            {
                "name": "Set variable1",
                "type": "SetVariable",
                "dependsOn": [],
                "userProperties": [],
                "typeProperties": {
                    "variableName": "varTime",
                    "value": {
                        "value": "@formatDateTime(convertFromUtc(utcnow(), 'Pacific Standard Time'), 'yyyy/MM/dd HH:mm:ss tt')",
                        "type": "Expression"
                    }
                }
            }
        ],
        "variables": {
            "varTime": {
                "type": "String"
            }
        },
        "annotations": []
    }
}

Hope this helps.

Share via

How to get 24 hours time in format yyyy-m format-dd hh:mm:ss

2 answers

Your answer