Database References: select dual getDate sysdate current date sysibm sysdummy1 dummy oracle MS Sql Server DB2

Showing posts with label select dual getDate sysdate current date sysibm sysdummy1 dummy oracle MS Sql Server DB2. Show all posts

Monday, 7 November 2011

SELECT getDate(); -- MS SQL Server

SELECT sysdate FROM dual; --Oracle

SELECT current date FROM sysibm.sysdummy1; -- DB2