Eko- first off, sorry for the informality, i don't have a clue as to the region of the world you are from, nor which pronoun to use to address you, so i decided to settle with being informal
now, there's two solutions. i don't know which is better for you, but the best thing i can think of is to reference the response of Deane Rothenmaier and say to use that response to learn WHY you were having a problem. now that we have explained WHY there is a problem, we need to figure out the best solution. to do this we need to look at what your situation is. from the line >> I have question. I got a piece of date data from MySQL i know you are interacting PERL and MySQL. here's the good news, MySQL actually has a large number of function meant to be helpful and when you can have the DB do what you want, it will be the fastest way most of the time due to streamlining done by the folks over at MySQL. in this case, i know from PHP experience that PERL does not need to do the work. you will need to evaluate this as a possibility for your situation, but i suggest getting the orielly book i have on MySQL i am not sure off the top of my head having not used it for a little... i believe it's "Managing and Using MySQL" I've got some links at the end to MySQL books by oreilly. moving onto the point.... there are functions WITHIN MySQL for adding dates. for the exact use, see the online manual at the MySQL official website, or your favorite MySQL book (and if your book doesn't have it, i would suggest finding a new favorite book) the other option is converting your MySQL to epoch, adding the seconds since that is what it LOOKS like you are trying to do, and then converting back to Julian. you can retrieve it as epoch instead of Julian by using UNIX_TIMSTAMP($field) in the call instead of $field. i know this from experience. for the site i made when i was doing that freelance for work, i used epoch for all my comparisons. i'm sure the time packages of PERL can give you the conversion functions if you want PERL to do the work instead of MySQL http://www.bookpool.com/sm/0596002114 http://www.bookpool.com/sm/059600446X http://www.bookpool.com/sm/0596001452 http://www.bookpool.com/sm/0596007892 -Josh Perlmutter Systems Engineer SeaChange International http://www.schange.com _______________________________________________ ActivePerl mailing list [email protected] To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
