Add year, Month and Day to date in Oracle

I've found that this works on 9.2.0.1 and later -

YEAR:
select sysdate + interval '1' year from dual
--Which return current date plus one year
Sysdate =01/01/2018(dd/mm/yyyy) Output: 01/01/2019
MONTH:
select sysdate + interval '1' month from dual
--Which return current date plus one Month
Sysdate =01/01/2018(dd/mm/yyyy) Output: 01/02/2018
DAY:
select sysdate + interval '1' day from dual
--Which return current date plus one day
Sysdate =01/01/2018(dd/mm/yyyy) Output: 02/01/2018

Add leading zero to make constant length of string using JavaScript

var acct1="12345678"
var acct=("000000000" + acct1).slice (-9);
document.write(acct);

output =012345678

Downgrade TalenD job Version

1) Open exported job folder.
2) Find file "talend.project", open it with any text editor like notepad in windows.
3) Find tag "TalendProperties"
4) Inside that tag find following element "productVersion"
5) Change its values from "Talend Open Studio for Data Integration-5.1.1" to "Talend Open Studio for Data Integration-5.0.2", please make sure to provide full major/minor version. like 5.0.2.r78327 instead of 5.0.2