[jivangoyal]

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]

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]

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