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

Can I use sql azure as a backup with log shipping or database mirroring?

156

What are the 10 characteristics of data quality?

956

Explain try...catch with sql server?

1024

How to identify current user in ssrs report?

403

Do you know what are acid properties of transaction?

961

Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?

1064

What’s the use of custom fields in report?

944

What are the built in functions in sql server?

987

What is mssql?

987

Explain the commands in sql server?

1043

role of sql sever 2005 in database rather than any other database

1944

what kind of lan types do you know? : Sql server database administration

980

What are the types of indexing?

1084

Tell me what do you mean by an execution plan? Why is it used? How would you view it?

883

What is shrink log file?

897