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

Can you index views?

935

what is package and it uses and how can u call a package

2067

What stored by the msdb?

1046

What does REVERT do in SQL Server 2005?

1011

How can I tell if sql server is 32 or 64 bit?

1012

Explain error handling in ssis?

1070

What happens when transaction log is full?

991

Do you know what are the steps to process a single select statement?

1018

Do you know what is rank function?

1126

Write a SQL command to insert and update only a particular field?

1190

What do you understand by coalesce in sql server?

1127

Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?

1059

Define Joins?

1074

Can we use where clause in union?

1124

How to backup encryption key ?

191