C# Tutorials and offshore development in India
    Tutorials   Resources   Forum   Communities   Interview   Jobs   Projects   Training   ASP.NET Web Hosting    
Silverlight Games | Mentor | Code Converter | Articles | Code Factory | Computer Jokes | Members | Peer Appraisal | IT Companies | Bookmarks | Polls | Revenue Sharing |


Prizes & Awards
My Profile



Active Members
TodayLast 7 Days more...

Play Silverlight Games or Submit your Silverlight applications and earn 90% AdSense revenue.

 New Feature: Community Sites: Create your own .NET community website and start earning from Google AdSense ! It's Free !




Forums » .NET » SQL Server »

COMPARISON BETWEEN SYSTEM DATE AND DATE STORED IN DATABASE


Posted Date: 22 Nov 2008      Posted By: baboo      Member Level: Bronze     Points: 1   Responses: 1



HI,

I AM WORKING IN SLITE TECHNOLOGIES AS DEVELOPER IN DOTNET.I STORED DATE VALUE IN DATABASE.I WANT SQL QUERY WHICH COMPARES SYSTEM DATE AND DATE STORED IN DATABASE.SEND ME IMMEDIATLY.


THANK YOU



Responses
Author: Sankar Venkat    23 Nov 2008Member Level: SilverRating:     Points: 3

Use this query.

SELECT empid,empname FROM empe
WHERE CONVERT(VARCHAR(10), emp.dob , 103) = CONVERT(VARCHAR(10),GETDATE(), 103)

Regards,
Sankar Venkat


Post Reply

 This thread is locked for new responses. Please post your comments and questions as a separate thread.
If required, refer to the URL of this page in your new post.
Next : SQL Select Querry
Previous : alter table in cursor
Return to Discussion Forum
Post New Message
Category: SQL Server

Related Messages


dotNet Slackers

About Us    Contact Us    Privacy Policy    Terms Of Use