Hi guys..,
Oracle
|
SQL Server
|
SELECT to_char(sysdate,'dd') FROM DUAL;
|
select day(getdate())
|
SELECT to_char(sysdate,'mm') FROM DUAL;
|
select month(getdate())
|
SELECT to_char(sysdate,'yyyy') FROM DUAL;
|
select year(getdate())
|
No comments:
Post a Comment