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

Answer Posted / sridhar kumar nelanti

we use getdate()in SQL server to view current date and in
oracle we use sysdate().

Is This Answer Correct ?    27 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

When cursors are useful?

586


What is partition index in sql server?

612


What are security principals used in sql server 2005?

521


What is difference between rownum and rowid?

517


Explain features and concepts of analysis services?

506






How to get a list of columns using the "sp_help" stored procedure in ms sql server?

590


Tell me what is difference between view and materialized view?

530


Why is the need for data conversion transformations?

510


What is difference between delete and truncate commands?

540


What are the types of ssrs?

108


How would we use distinct statement? What is its use?

619


Explain the stored procedure?

645


How do I find sql server instance name?

516


Explain Normalization and DE normalization

615


What do you mean by an execution plan?

576