I noticed trunc has a skillful way of working with dates.
First day of the month :
select trunc(sysdate,'MM') from dual;
Gives me 01-FEB-13
First day of the year:
select trunc(sysdate,'YY') from dual;
Gives me 01-JAN-13
Subscribe to:
Post Comments (Atom)
Integrations Lead - Lessons learnt
Integrations have been my passion for a while but like anything tech there is no credit given when things go right but always heaps of pres...
-
For most outbound interfaces bursting to content server and then picking the file from UCM is the best approach for large extracts. Default...
-
While developing Cloud integrations I could not find a single place for all details like InterfaceID or jobdefinitionname or job name etc. ...
-
Query to get a org at a particular depth - SELECT haou.name, haou.organization_id , ANCESTOR_PK1_VALUE, DISTANCE ,haou1.name LEVEL1_ORG ...
No comments:
Post a Comment