In Access 'Select date()' In Oracle 9i 'Select Sysdate from

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

Question Posted / selvaraj.v

Answer Posted / selvaraj.v

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

Is This Answer Correct ?

33 Yes

7 No

Please Help Members By Posting Answers For Below Questions

do you know how to configure db2 side of the application? : Sql server database administration

983

What are the export options of ssrs?

165

Explain the stored procedure?

985

application server is slow what may be the problem

2162

How can you control the amount of free space in your index pages?

1005

Explain the functionalities that views support?

1036

Is truncate autocommit?

894

What is a result set object returned by odbc_exec()?

948

What is the difference between a local and a global temporary table?

1052

Define self join in sql server joins?

898

What are the types of joins in sql?

1054

how to do partition in sqlserver

2404

How many database files are there in sql server 2000?what are they?

976

What is a fill factor?

1030

Does partitioning ssd reduce performance?

844