Get Date or Time for, Server

• Oracle

  SELECT TO_CHAR(CURRENT_DATE, 'DD-MON-YYYY HH:MI:SS') FROM DUAL; 

  or

  SELECT TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS') FROM DUAL;

• MySQL

  SELECT CURDATE();

• SQL Server

  SELECT GETDATE()
  GO

ที่มา: http://stackoverflow.com