Date fields in Oracle hold the time, but by default, the time is not displayed.

Below is a sample of how to format the date with time:

   TO_CHAR(CREATION_DATE, 'YYYY-MM-DD HH24:MI:SS') as CREATION_DATE

Here’s a sample of how I GAC and UnGAC DLLs from Powershell. I think I got this on StackOverflow, but don’t have the link handy now.
(GAC, of course, refers to the .NET Global Assembly Cache. All BizTalk artificats and C# programs must be in the GAC to be called from a BizTalk orchestration).


function GacDll ($dllpath)
{
    Write-Host " "  # blank line 
    if (!(Test-Path $dllpath)) 
       {

          Write-Host "`n dllpath not found: $dllpath  `n`n" 
          exit
       }
    [System.Reflection.Assembly]::Load("System.EnterpriseServices, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a")            
    $publish = New-Object System.EnterpriseServices.Internal.Publish            
    $publish.GacInstall($dllpath)
    Write-Host "Published to GAC: $dllpath" 

}

function unGacDLL ($dllpath) 
{
    if (!(Test-Path $dllpath)) 
       {

          Write-Host "`n dllpath not found: $dllpath  `n`n" 
          exit
       }
    [System.Reflection.Assembly]::Load("System.EnterpriseServices, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a")            
    $publish = New-Object System.EnterpriseServices.Internal.Publish            
    $publish.GacRemove($dllpath) 
    Write-Host "Removed from GAC: $dllpath" 
  
}

cls

$dllpath1 = "c:\VSTS\ABC.Oracle\ABC.OracleDB.Helpers\ABC.OracleDB.Helpers\bin\Debug\ABC.OracleDatabase.Helpers.dll"
UnGacDll $dllPath1 

$dllpath2 = "c:\VSTS\ABC.BizTalkNonDB.Helpers\ABC.BizTalkNonDB.Helpers\bin\Debug\ABC.BizTalkNonDB.Helpers.dll"
GacDll $dllPath2 
 
$date = Get-Date -Format "yyyy-MM-dd hh:mm:ss"
Write-Host "`nDate/Time Completed: $date "