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

Why use stored procedures in sql server?

987

How to update muliple row in single query?

1036

what are user defined datatypes? : Sql server database administration

951

What is a view in sql?

958

What are types of scd? : sql server analysis services, ssas

996

What are orphan records?

914

What is CTE in SQL

924

How many types of triggers are there?

1042

Working with TLogs

1819

How to find the login name linked to a given user name?

989

Can an entity have two primary keys?

961

what are the new features introduced in sql server 2000? : Sql server database administration

896

What is database replication? What are the different types of replication you can set up in sql server?

944

what is the difference between a primary key and a unique key? : Sql server database administration

978

What are functions in the sql server?

1183