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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is dml command?

542


What is onf in normalization form?

567


How to backup SQL Server Reporting Services ?

103


How to execute the cursor queries with "open" statements?

609


Define left outer join in sql server joins?

551






What is an indexing technique?

488


How to add a new column to an existing table with "alter table ... Add" in ms sql server?

571


What is master database? : SQL Server Architecture

525


Tell me what are the essential components of sql server service broker?

503


Why we should not use triggers?

534


What is PROJECTION Operation?

607


How to fine-tune reports?

151


What are the underflow and overflow behaviors on float literals?

570


Tell me something about security and sql azure?

100


Do you know how to make remote connection in database?

548