need help for handling dates [urgent]

jivangoyal · 06-02-08, 05:31 PM

I've a project where need to store date of some event in specific format "mm/dd/yyyy hh:mm:ss" and then access these dates to compare it with the current datetime to get the difference between datetime stored and now.

for this purpose I need
1) How to get the current datetime in the needed format
2) How to compare the stored datetime string with the current datetime to calculate the minutes expired from the stored datetime to now.

**sk_kireeti** · 06-02-08, 06:48 PM

are you using DB to store date? If you are using Oracle DB, you can directly do it at DB server and Oracle has functions for that... no need to code it. Otherwise, you can refer to asktom.com for Oracle based solution.

Thanks,
Krishna

jivangoyal · 06-02-08, 07:17 PM

I'm using the ASCII text file to store and retrieve the information. in this file a complete string of information is stored in addition to date. and I need to use this stored date for various operations specified. I'm retrieving this date string with split function

06-02-08, 05:31 PM	#1 (permalink)
jivangoyal Junior Member Join Date: Feb 2008 Posts: 2 Thanks: 0 Thanked 0 Times in 0 Posts Thanks: 0 Thanked 0 Times in 0 Posts Rep Power: 1	need help for handling dates [urgent] I've a project where need to store date of some event in specific format "mm/dd/yyyy hh:mm:ss" and then access these dates to compare it with the current datetime to get the difference between datetime stored and now. for this purpose I need 1) How to get the current datetime in the needed format 2) How to compare the stored datetime string with the current datetime to calculate the minutes expired from the stored datetime to now.

06-02-08, 06:48 PM	#2 (permalink)
sk_kireeti Super Moderator Join Date: Feb 2006 Location: Hyderabad Posts: 2,355 Thanks: 117 Thanked 241 Times in 198 Posts Thanks: 117 Thanked 241 Times in 198 Posts Blog Entries: 4 Rep Power: 51	Re: need help for handling dates [urgent] are you using DB to store date? If you are using Oracle DB, you can directly do it at DB server and Oracle has functions for that... no need to code it. Otherwise, you can refer to asktom.com for Oracle based solution. Thanks, Krishna __________________ Give 1 cup rice to a hungry Indian just by a mouse click. No money, no form filling, no hassle... Click here for the donation.

06-02-08, 07:17 PM	#3 (permalink)
jivangoyal Junior Member Join Date: Feb 2008 Posts: 2 Thanks: 0 Thanked 0 Times in 0 Posts Thanks: 0 Thanked 0 Times in 0 Posts Rep Power: 1	Re: need help for handling dates [urgent] I'm using the ASCII text file to store and retrieve the information. in this file a complete string of information is stored in addition to date. and I need to use this stored date for various operations specified. I'm retrieving this date string with split function

Thread Tools
Show Printable Version Email this Page
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to find days between two dates in java?	raghuvamshi_ece	JAVA Technologies	4	18-10-07 05:30 PM
How to compare dates in javascript?	balasri1984	Ask for Suggestion	3	07-02-07 06:53 PM
Sql - Which date function is used to find the difference between two dates?	radhika_btech	Oracle Interview / Technical Questions	1	26-01-07 03:44 PM
Comparing two dates	skhyd	JAVA Technologies	2	15-01-07 12:17 PM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)