In Sql Server It will be ( Select getDate() ) And in ORacler (Select SysDa

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

Question Posted / vineet yadav

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

Please Help Members By Posting Answers For Below Questions

How do clustered indexes store data?

1085

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

982

What is view in sql?

881

How can you set the threshold at which sql server will generate keysets asynchronously?

970

How to rename an existing column with sql server management studio?

982

Does sql server 2016 have ssms?

939

What is a mixed extent?

995

What is subquery? Explain the properties of a subquery?

960

What is difference between drop truncate and delete?

1067

What options are there to delete rows on the publisher and not on the subscriber? : sql server replication

1193

Can we linked SharePoint to a SQL database?

1006

What is 1nf 2nf and 3nf?

876

What is transaction server implicit?

984

What is star, snowflake and star flake schema? : sql server analysis services, ssas

1130

in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration

1035