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 the difference between value type and reference type?

0 Answers  

if no size is defined while creating the database, what size will the database have? : Sql server administration

0 Answers  

Explain trigger and trigger types?

0 Answers  

What is Full Outer Join?

3 Answers  

How to get @@error and @@rowcount at the same time?

0 Answers  

Explain what are partitioned views and distributed partitioned views?

0 Answers  

What is isnull() operator?

0 Answers  

can anyone explain me the concept of Serialization in Detail and Clear? plz its urgent i have interview on friday (15th feb)

1 Answers  

What is referential integrity? What are the advantages of it?

4 Answers   Descon, Digital Domain,

How much space does sql server 2016 take?

0 Answers  

Is it possible we can connect our SQL database to GUI application? If it is yes than how tell me the explanation

2 Answers  

Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?

0 Answers