Alternative way to DetDate() function?

Answer Posted / brahma prakash

SELECT current_date(for currentdate only)
SELECT NOW()

Is This Answer Correct ?    0 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the stuff?

711


Do you know what is user defined datatypes and when you should go for them?

706


What are different backups available in sql server?

758


What is isolation levels?

752


What is left outer join in sql server joins?

694






Tell me what do you understand by a view? What does the with check option clause for a view do?

799


What are page splits? : SQL Server Architecture

744


How to insert stored procedure result into temporary table?

762


After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas

729


what happens on checkpoint? : Sql server database administration

696


Explain aggregate functions?

783


What are the different types of replication are there in sql server 2000?

760


What do you understand by SQL*Net?

782


What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

729


How to insert and update data into a table with "insert" and "update" statements?

699