In Access We USE 'Select Date()' In Sql server 2000 'Select

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

Question Posted / rajiv rohilla

Answer Posted / rajiv rohilla

In Access We USE 'Select Date()'
In Sql server 2000 'Select getdate()'
In Oracle 'Select SysDate() from dual'

Is This Answer Correct ?

43 Yes

13 No

Please Help Members By Posting Answers For Below Questions

Define Unique Key?

942

Why de-normalization required?

940

What is delete query?

896

What are the different sql server versions?

931

Explain an automatic checkpoint

914

What command would you use to create an index?

982

How to convert binary strings into integers in ms sql server?

962

What do you understand by recursive stored procedure?

873

Explain the steps to use transact-sql cursor?

957

How many databases Microsoft SQL server provides?

1028

How can i Relate Tables in SSIS

1033

Where do you find the default Index fill factor and how to change it?

1015

Explain linked server in sql?

1150

Explain can SSRS reports Cache results?

149

Can foreign key be deleted?

871