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 2008

Member Level: Silver

Rating:

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