Prepare for your Next Interview

• GeekInterview
• Knowledge base
• Interview Questions
• Tech FAQs

Get records from table month, day, year wise.

This is a discussion on Get records from table month, day, year wise. within the DB2 forums, part of the Databases category; How to get the records from table only month wise, day wise, year wise. If the records are arrange in the form of dd-mm-yyyy. Question asked by visitor ...

Geeks Talk > Databases > DB2 Get records from table month, day, year wise.

User Name Remember Me? Password

Register

FAQ

Members List

Calendar

Mark Forums Read

Thread Tools

Display Modes

#1 (permalink)   06-06-2007

Geek_Guest Expert Member   Join Date: Feb 2007 Posts: 1,279 Thanks: 0 Thanked 164 Times in 138 Posts

Get records from table month, day, year wise. How to get the records from table only month wise, day wise, year wise. If the records are arrange in the form of dd-mm-yyyy. Question asked by visitor sunil bansal

Sponsored Links

#2 (permalink)   06-11-2007

kckinney Junior Member   Join Date: May 2007 Posts: 15 Thanks: 0 Thanked 0 Times in 0 Posts

Re: Get records from table month, day, year wise. Could you rephrase the question? Are you trying the select on a specific month, day or year? Or could you be trying to reformat the key for output? kk

#3 (permalink)   06-12-2007

SQLTweety Junior Member   Join Date: May 2007 Posts: 16 Thanks: 0 Thanked 3 Times in 3 Posts

Re: Get records from table month, day, year wise. Sunil , Did you mean that you want fetch records only for perticular month / year / day? If yes, To get the records for for perticular month Select * from my_table where month(my_date_Column)= month_i_want. Similarly for year , Select * from my_table where Year(my_date_Column)= Year_i_want. HTH Regards,

Geeks Talk > Databases > DB2

« Hi friends | Exists, System Parameter, Abend, Logged Members »

Thread Tools

Show Printable Version Email this Page

Display Modes

Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to retrieve top 10 records from ORACE Table	ppooven	Oracle	2	07-12-2007 07:49 AM
Department wise max salary	Geek_Guest	Oracle	2	06-16-2007 09:22 AM
How to get the result column wise	dhandhan	QTP	3	04-19-2007 05:05 AM
I want to load odd number records into one target table	ggk.krishna	Data Warehousing	2	04-18-2007 12:22 AM
I want load the duplicate records to seperate table	Geek_Guest	Data Warehousing	4	04-06-2007 03:10 AM

All times are GMT -4. The time now is 01:48 PM.