Hi,
You can fetch the records based on the below query,

SELECT * FROM <table_name> where YEAR(column_date)=2005 with ur

Please let me know if you face any issue

Thanks & Regards,
Vignesh

-----Original Message-----
From: Khan Nadeem
[mailto:db2udbdba-ezmlmshield-x69935725.[Email address protected]
Sent: Wednesday, October 24, 2007 2:18 PM
To: LazyDBA Discussion
Subject: reg dates


Hi gurus



If I want to search some rows from my table based on a criteria



Where DOB ='2001'



I mean only records with respect to 2001

So how is it possible in DB2

Do let me know



Thanks,

Nadeem Khan





This message contains information that may be privileged or confidential
and is the property of the Capgemini Group. It is intended only for the
person to whom it is addressed. If you are not the intended recipient,
you are not authorized to read, print, retain, copy, disseminate,
distribute, or use this message or any part thereof. If you receive this
message in error, please notify the sender immediately and delete all
copies of this message.


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments.

WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email.

www.wipro.com

DB2 & UDB email list listserv db2-l LazyDBA home page