Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

i pick the anydate betwen START DATE and END DATE in db2

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
poturaju

New User


Joined: 12 Apr 2011
Posts: 2
Location: india

PostPosted: Tue Apr 12, 2011 3:55 pm    Post subject: i pick the anydate betwen START DATE and END DATE in db2
Reply with quote

Hi Friends,
I have start date and End date fields, but i pick the any single date between start date and end date.
How to get single date between them?
pls give me solution for this query.
Back to top
View user's profile Send private message

dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6968
Location: porcelain throne

PostPosted: Tue Apr 12, 2011 4:02 pm    Post subject:
Reply with quote

FETCH FIRST ROW ONLY
Back to top
View user's profile Send private message
Escapa

Senior Member


Joined: 16 Feb 2007
Posts: 1399
Location: IL, USA

PostPosted: Tue Apr 12, 2011 4:14 pm    Post subject:
Reply with quote

Welcome to forum..

Quote:
How to get single date between them?

I don't understand this. Which date?

What is your requirement?
Back to top
View user's profile Send private message
chandracdac

New User


Joined: 15 Jun 2007
Posts: 92
Location: bangalore

PostPosted: Wed Apr 13, 2011 2:43 pm    Post subject: Reply to: i pick the anydate betwen START DATE and END DATE
Reply with quote

Hi Pothuraju,

Please explain your requirement clearly. so that some one will try to help you.

Thanks,
Chandra.
Back to top
View user's profile Send private message
Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1770
Location: Bloomington, IL

PostPosted: Thu Apr 14, 2011 1:38 am    Post subject: Re: i pick the anydate betwen START DATE and END DATE in db2
Reply with quote

poturaju wrote:
I have start date and End date fields, but i pick the any single date between start date and end date.
How to get single date between them?

This question is badly phrased and rather ambiguous. English is undoubtedly not your "milk tongue", but you must try to achieve and exhibit greater fluency in it if you expect to communicate effectively -- and have a successful career in IT.

Now, do you want any date between the start and end dates, or do you want a specific date between them? If the latter, how will it be presented that it will not itself be a date?
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts How to add header with Date(YYMMDD) i... Rajan Moorthy DFSORT/ICETOOL 2 Thu Jul 06, 2017 11:44 pm
No new posts How to Clear all TSQs during CICS sta... Hooman24 CICS 10 Mon Jun 26, 2017 9:46 pm
No new posts Validate date and numeric fields and ... Rick Silvers DFSORT/ICETOOL 6 Thu May 11, 2017 6:51 pm
No new posts LISTIDR compiled date/time jerryte IBM Tools 3 Thu Apr 20, 2017 7:37 pm
No new posts SUBSTR for Date functions Shaheen Shaik DB2 4 Thu Apr 06, 2017 2:14 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us