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: 6966
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: 1746
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 CICS START AND CANCEL blayek CICS 1 Wed Dec 07, 2016 3:27 am
No new posts TOT & DATE parameter in ICEMAN hemanthj642 DFSORT/ICETOOL 4 Mon Nov 14, 2016 5:19 am
This topic is locked: you cannot edit posts or make replies. How to pass the previous month date i... Suganya87 DFSORT/ICETOOL 5 Mon Oct 31, 2016 4:13 pm
This topic is locked: you cannot edit posts or make replies. Get correct date and time when curren... balaji81_k DB2 24 Fri Oct 14, 2016 10:40 pm
No new posts Joinkeys operation betwen VB and FB file Susanta SYNCSORT 4 Sun Sep 25, 2016 9:49 pm


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