i have to calculate local time and date in our data base
i have gmt time range from 00:00 to 23:59 and offset is in same range but with + an - sign
when + then we have to substract and when - then we have add and adjest the date with the given time
for eg gmt id 23:30 and ofset is +2:30 and date is '28-08-2010'
then my local time is 23:30 -2:30 =21:00 and date will not change
i want a cricteria like when offset get added then value should not be like 22:60 insted of this it is 23:00 and if it is exiding 24 then date should be increase and if time is - after gmt+ofset then date should be redused
Please give me a idea so i can solve it.
View Complete Post