Monday, 7 November 2011

Getting Date from Oracle, MS SQL Server and IBM DB2 using dummy table

SELECT getDate(); -- MS SQL Server


SELECT sysdate FROM dual; --Oracle


SELECT current date FROM sysibm.sysdummy1; -- DB2

No comments:

Post a Comment