SELECT GETDATE() AS 'Current Date'
GO

i donot abt the SQLserver2000and MSaccess.But in ORACLE we 
get current date by following SQLstmt:
SELECT sysdate() FROM DUAL;

we use getdate()in SQL server to view current date and in 
oracle we use sysdate().

In Access We USE 'Select Date()'
In Sql server 2000 'Select getdate()'
In Oracle 'Select SysDate() from dual'

In Access 'Select date()'
In Oracle 9i 'Select Sysdate from dual;'
In SQL Server 2000 'Select Getdate()'

This command is not working, I transferred MySQL database 
to SQL Server 2000 database.

Please tell me the actual command to use

To display current systems date
 
 DateTime.Now

select getdate(); in sql server 2000

slect TO-CHAR(syssdate,'dd-mm-yy h:mipm') from dual; this is
oracle query..

select date() does not work in Access 97.

Access 2000 , i have tried.

select date()  as CurrDate
select now() as CurrNow 'This will also work but it will
give you time also.


Output 

CurrDate
----------
11/17/2009

CurrNow
----------
11/17/2009 11:00:34 PM