Link's

Markdown Mastering

Tech On The Net

OracleTutorial

SQL Server Docs Date Time

Oracle

SELECT SYSDATE,       TO_CHAR(SYSDATE,'DD'),       TO_CHAR(SYSDATE,'MM'),       TO_CHAR(SYSDATE,'MON'),       TO_CHAR(SYSDATE,'RRRR'),       TO_CHAR(SYSDATE,'HH24:MI:SS'),       TO_CHAR(TO_DATE(SYSDATE),'MM/RRRR'),       TRUNC(SYSDATE,'MONTH'),       TRUNC(SYSDATE, 'MONTH')-1,       TRUNC(SYSDATE, 'YEAR'),       TRUNC(LAST_DAY(SYSDATE)),       TO_CHAR(SYSDATE,'DD/MM/RRRR HH24:MI:SS'),       TO_CHAR(SYSDATE,'DD/MM/RRRR'),       LAST_DAY(ADD_MONTHS(SYSDATE,-2))+1,       LAST_DAY(ADD_MONTHS(SYSDATE,-1)),       TO_DATE(TRUNC(LAST_DAY(ADD_MONTHS(SYSDATE,-2)))+1,'DD/MM/RRRR'),       floor(MONTHS_BETWEEN(SYSdate,SYSDATE-60) /12) + 1 AS MONTHS_BETWEEN,       MONTHS_BETWEEN(SYSdate,SYSDATE-60) AS MONTHS_BETWEEN,       ADD_MONTHS(SYSDATE,-12)  FROM DUAL

SELECT PRODUTO, CATEGORIA, RANK () OVER ( ORDER BY PRODUTO) RANKINGPROD, DENSE_RANK () OVER ( ORDER BY CATEGORIA) RANKINGCAT  FROM (SELECT 'p1' AS PRODUTO, 'c1' AS CATEGORIA FROM DUALUNION ALLSELECT 'p2' AS PRODUTO, 'c1' AS CATEGORIA FROM DUALUNION ALLSELECT 'p3' AS PRODUTO, 'c1' AS CATEGORIA FROM DUALUNION ALLSELECT 'p4' AS PRODUTO, 'c2' AS CATEGORIA FROM DUALUNION ALLSELECT 'p5' AS PRODUTO, 'c2' AS CATEGORIA FROM DUAL) AX

SQL Server

select convert(datetimeoffset,'01/01/2018') --2018-01-01 00:00:00.0000000 +00:00

select SYSDATETIMEOFFSET() --2018-07-16 11:17:07.0469589 -03:00

select convert(int,CONVERT(CHAR(10), GETDATE(),112))  --20180716