i donot abt the SQLserver2000and MSaccess.But in ORACLE we get current da

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

Question Posted / nikita

Answer Posted / nikita

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

Is This Answer Correct ?

32 Yes

14 No

Please Help Members By Posting Answers For Below Questions

Explain about Joins?

992

What is the security principal at the database level that represents your session?

942

When I delete any data from a table, does the sql server reduce the size of that table?

1019

What is the difference between mysql and mysqli?

1206

Which table keeps information about stored procedures?

939

How to transfer a table from one schema to another?

1003

What is a matrix in ssrs?

153

Tell me what is the stuff and how does it differ from the replace function?

981

how can u get last observation in an unknown dataset ?

2436

Write a SQL queries on Self Join and Inner Join.

1043

What is normalization 1nf 2nf 3nf?

1060

How to change the system date and time from SQL Plus Terminal ?

1221

What are xml indexes?

952

What is a mutating table error and how can you get around it?

1051

What is constraints and its types?

950