Answer / lrk

SELECT GETDATE() AS 'Current Date'
GO

Answer / rajiv rohilla

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

Answer / selvaraj.v

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

Answer / sridhar kumar nelanti

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

Answer / nikita

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

Answer / jayesh l lolariya

select getdate(); in sql server 2000

Answer / kaveesh

select sysdate from dual; It works in ORACLe 10g.
Kaveesh

Answer / suhel

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

Please tell me the actual command to use

Answer / vineet yadav

In Sql Server It will be ( Select getDate() )
And in ORacler (Select SysDate() from dual;)

Answer / parmanand

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

what is replication? where do u use Go Keyword?

1 Answers   Satyam,

Explain what are the events recorded in a transaction log?

0 Answers  

Define inner join in sql server joins?

0 Answers  

What is use of dbcc commands?

0 Answers  

What is a ddl statement?

0 Answers  

List the various tools available for performance tuning?

0 Answers  

What is table valued function and scalar valued functions?

0 Answers  

How to assign null values to variables or columns?

0 Answers  

What is updatable resultset?

0 Answers  

What is co-related sub query?

0 Answers  

What is a benefit of using an after insert trigger over using a before insert trigger?

0 Answers  

What does the INSTEAD OF trigger do?

3 Answers