IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

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


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
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
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
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
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
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: 1788
Location: Bloomington, IL

PostPosted: Thu Apr 14, 2011 1:38 am
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Replacing 'YYMMDD' with date, varying... SYNCSORT 3
No new posts Modifying Date Format Using DFSORT DFSORT/ICETOOL 9
No new posts Need to convert date format DFSORT/ICETOOL 20
No new posts Need help to append a date&tsp at... DFSORT/ICETOOL 9
No new posts Fetch data from programs execute (dat... DB2 3
Search our Forums:

Back to Top