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

Answer Posted / vineet yadav

In Sql Server It will be ( Select getDate() )
And in ORacler (Select SysDate() from dual;)

Is This Answer Correct ?    5 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we hide the definition of a stored procedure from a use?

867


How to view the error log for any specific instance? : sql server database administration

771


What it means to be triggered?

662


What is the difference between ddl,dml and dcl commands?

810


What is a partitioned view?

769






If any stored procedure is encrypted, then can we see its definition in activity monitor?

728


What is the standby server?

682


What is application role in sql server database security? : sql server security

753


what's sql server? : Sql server database administration

681


What are the differences between clustered and non-clustered index?

714


How to get a list of columns in a view using "sys.columns" in ms sql server?

723


How to turn off warning messages during php execution?

722


What is nolock hint in sql server 2008

824


What is NOT NULL Constraint in sql server 2012?

751


How to connect ms access to sql servers through odbc?

732