Prepare for your Next Interview
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 ...
|
|||
|
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 |
|
|||
|
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 |
|
|||
|
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, |
![]() |
|
| Thread Tools | |
| Display Modes | |
|
|
|
||||
| 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 |