How to Get Numeric Year, Month, Day from a Date in Oracle PL/SQL

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>

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> […]

Recent Posts




All Rights Reserved Theme by 404 THEME.