Converting OpenInsight Date Time to Powershell Date Time
This is a walk through showing the conversion of Date Time values to a Powershell Date Time value.
If you generate your Date Time values in OpenInsight with this format:
OIDateTime = Oconv(Date(),'D2/') : " " : Oconv(Time(),'MTHS')
You'll get a value looking like this:
12/07/15 01:54:37PM
Powershell can convert this format to an internal format with the Get-Date command:
$PSDateTime = Get-Date $OIDateTime
The variable $PSDateTime contains .NET date time reference.
As a bonus, it now becomes much easier to convert the date time value to other formats. Here is an example to convert the value to MySQL DateTime string:
$MySQLDateTime = Get-Date $PSDateTime -Format "yyyy-MM-dd HH:m:ss"
The variable $MySQLDateTime now contains a string "2015-12-07 13:54:37" which can be easily inserted into a standard MySQL datetime column.
Author
Jared Bratu
Long time network sysadmin with proclivity to coding. Why do something twice when it can be scripted once? With a wide range of familiar technology skills Jared tries to apply the best aspects of each technology to projects leaving them better than they were before.
Leave a comment