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

Explain something about security and SQL Azure?

106


How to delete a login name in ms sql server?

706


How to apply filtering criteria at group level with the having clause in ms sql server?

746


What is “asynchronous” communication in sql server service broker?

721


What is an example of a foreign key?

695






Can I disable or restrict ssrs export formats (rendering formats)?

126


What is mean by candidate key?

747


What is the difference between char and varchar2 datatype in sql?

744


What is a non equi join?

733


What is table constraint?

729


what changed between the previous version of sql server and the current version? : Sql server database administration

702


What number aggregate functions are accessible there in sql?

772


Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

742


What is self join in sql server joins?

737


as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration

728