Home / Questions / 203528
Accepted
Ricardo Soria
Asked: 2020-10-11 09:23:58 +0800 CST 2020-10-11 09:23:58 +0800 CST

Change date format from Epoch to datetime in PowerShell

  • 772

I have a String that represents a time in Epoch and I need the correct format to be able to enter it in a SQL Server database, from PowerShell. So far I can change the Epoch format to a very long date format, EXAMPLE:

Date in Epoch to convert: 746181000

Function I use:

[timezone]::CurrentTimeZone.ToLocalTime(([datetime]'1/1/1970').AddSeconds('746181000'))

The output is the following:

Tuesday, August 24, 1993 3:30:00 AM

What I really need is the date in this format:yyyy-MM-dd HH:MM:ss

So my desired output would be1993-08-24 03:30:00

datetime

1 Answers

  1. Best Answer

    You can do the following:

    According to the function you defined above:

    [timezone]::CurrentTimeZone.ToLocalTime(([datetime]'1/1/1970').AddSeconds('746181000'))

    You can use the Get-Date command along with the Format parameter to manipulate the output as per your need, as follows:

    $epochOut = [timezone]::CurrentTimeZone.ToLocalTime(([datetime]'1/1/1970').AddSeconds('746181000'))
$outputFixed = $epochOut | Get-Date -Format "yyyy-MM-dd hh:mm:ss"
    • 0