sqlserver date query
I am new to development and want to know the professional way to deal with dates in sqlserver. In my applications mainly we deal with the DATE datatype and no concern with time part. Also maintaining the format dd/mm/yyyy

so for example if i have the table with the following structure.

EmployeeTable  
---------------
emp_id int  
emp_name varchar(50)  
join_date date  


and if i want to query "join_date" in between start date and end date and pass the dd/mm/yyyy as stored procedure criteria and want to query.

What is the professional way to handle dates. I always convert date in varchar and then do the comparison which i guess unprofessional way of doing it. So please guide how to do it in procedure with example i would appreciate.

thanks

sqlserver date query
===

I am new to development and want to know the professional way to deal with dates in sqlserver. In my applications mainly we deal with the DATE datatype and no concern with time part. Also maintaining the format dd/mm/yyyy

so for example if i have the table with the following structure.

EmployeeTable  
---------------
emp_id int  
emp_name varchar(50)  
join_date date  


and if i want to query "join_date" in between start date and end date and pass the dd/mm/yyyy as stored procedure criteria and want to query.

What is the professional way to handle dates. I always convert date in varchar and then do the comparison which i guess unprofessional way of doing it. So please guide how to do it in procedure with example i would appreciate.

thanks
