Use the Oracle PL/SQL “Extract” function to extract the Year, Month, Day into separate columns for sorting/grouping: <pre> select EXTRACT(YEAR FROM Creation_Date) as Year, EXTRACT(MONTH FROM Creation_Date) as Month, EXTRACT(DAY FROM Creation_Date) as Day, Creation_Date from PO.PO_HEADERS_INTERFACE POI </pre>
Month: September 2019
How to format a date in Oracle PL/SQL
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: <pre> TO_CHAR(CREATION_DATE, 'YYYY-MM-DD HH24:MI:SS') as CREATION_DATE </pre> Example: <pre> select Creation_Date, TO_CHAR(CREATION_DATE, 'YYYY-MM-DD HH24:MI:SS') as CREATION_DATE_Fmt from PO.PO_HEADERS_ALL where Creation_Date is not null order by Creation_Date desc […]
Gac/UnGac (GacUtil) from Powershell
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). <pre> […]