SELECT current_date(for currentdate only) SELECT NOW()

Alternative way to DetDate() function?

Question Posted / brahma prakash

Answer Posted / brahma prakash

SELECT current_date(for currentdate only)
SELECT NOW()

Is This Answer Correct ?

0 Yes

3 No

Please Help Members By Posting Answers For Below Questions

Explain temporary table vs table variable by using cursor alternative?

528

Is sql server a database?

540

How to test a dml trigger in ms sql server?

583

Explain a join?

623

What are points to remember while using the fillfactor argument?

534

What are the built in functions in sql server?

493

What is spid in sql server profiler?

544

How optimize sql query with multiple joins in sql server?

417

What is hot add cpu in sql server 2008?

526

Which tools are available to manage SQL Azure databases and servers?

how many no of arguments can be passed in procedures and functions

4787

What is the default schema of your login session in ms sql server?

595

When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?

507

Explain about protocol layer present in SQL server?

611

Define master database?

585