In Access We USE 'Select Date()' In Sql server 2000 'Select

How do we get current date in SQL Server 2000, Oracle, MS
Access?

Question Posted / rajiv rohilla

Answer Posted / rajiv rohilla

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

Is This Answer Correct ?

43 Yes

13 No

Please Help Members By Posting Answers For Below Questions

What is the difference between for xml raw and for xml auto?

1075

What is sub query and its properties?

1021

How to delete duplicate rows in sql server?

1145

Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

1119

How to handle error or exception in sql?

1030

How to select some specific rows from a table in ms sql server?

1051

What is database isolation in sql server? : sql server database administration

1147

Explain cross join or cartesian product in sql?

922

What do mean by xml datatype?

1168

How do I find the default sql server instance?

986

When multiple after triggers are attached to sql table, how to control the order of execution?

1099

Where does the copy job runs in the log shipping primary or secondary? : sql server database administration

1094

How many types of dimensions are there and what are they? : sql server analysis services, ssas

1118

Define cursor locking

1055

What is set nocount on and what is set nocount off?

991