Re: Adding a relative amount of time to an absolute time.

On 7 April 2015 at 13:42, Marc Guay <marc.guay@gmail.com> wrote: > Hi Richard, > > I looked around a bit and it does seem clunky to convert a HH:MM:SS > string to a DateInterval object. Why not store the buffer time as > seconds only, and then do something like > > $date = new DateTime($event_datetime); > $date->add(new DateInterval('P'.$buffer_time.'S')); > echo $date->format('Y-m-d') . "\n"; > > Marc > > On 7 April 2015 at 07:45, Richard Quadling <rquadling@gmail.com> wrote: > > Hi. > > > > This sort of stuff always makes me wonder what it is I am missing. > > > > The users are asked to enter a buffer time in the format HH:MM > > > > This time will be added to the end of an event datetime to determine what > > the next available event will be for that user. > > > > The entered value is stored in the DB as a time type (so is returned as a > > string "HH:MM:SS"). > > > > Can I use anything in DateTime to handle this (I was thinking of > > DateTimeInterval but that doesn't want to deal with a simple time only > > string). > > > > My other option is to parse out the string into H, M and S and then > > construct that as a strtotime sort of thing. > > > > In general, this sort of parsing always suggests I've missed a > > trick/function/method. > > > > So, is there something I'm missing? > > > > Regards, > > > > Richard. > > > > > > > > -- > > Richard Quadling > > Twitter : @RQuadling > > EE : http://e-e.com/M_248814.html > > Zend : http://bit.ly/9O8vFY > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > I'm using a generator that understands the mySQL TIME type (and so renders and intput masks accordingly). In my class to get the content, I just put TIME_TO_SEC(bi.bufferTime) and I get seconds and that's all so much easier! I was looking purely for PHP, but data retrieval was the better place to fix this. Thanks. -- Richard Quadling Twitter : @RQuadling EE : http://e-e.com/M_248814.html Zend : http://bit.ly/9O8vFY