Select only date in sql query

i have a database column "Login_Date" which is of data type DateTime. It means it accepts both date and time in the same column. I want to retrieve only date from this column. How to write Select sql query form my condition.. Hope you understand what i want.
Posted by Prince Mahajan 3/23/2014 10:31:48 AM
Total Answers : 1
Answer 1
Your sql query will be
SELECT CONVERT (DATE, GETDATE()) 'Date Part Only'

RESULT:
Date Part Only
--------------
2013-07-14
Posted by StepCoder Team 3/26/2014 12:07:12 PM
Post your answer
Preview
Sign in to your account
Your Email : 
Password :   
Forgot your password
Don't have StepCoder account ?
Create a new account
 
Follow me on twitter
About Me
Harpreet Singh
I began programming with C++ when i was 17. Then at the middle of my study .NET came. Then I began to read C# and VB.NET. By the time i learnt SQL and ASP.NET, and developed some websites such as news portals that are active now. Currently i am running my own Software company.
Answer these questions! If you know the answer.