Re: Last Second of Day for the given date?
[email protected] (Dave Rolsky)
| Newsgroups | perl.datetime |
|---|---|
| Message-ID | <[email protected]> |
On Thu, 12 Mar 2009, Bill Moseley wrote: > On Thu, Mar 12, 2009 at 02:28:34PM -0500, Dave Rolsky wrote: >> On Thu, 12 Mar 2009, Bill Moseley wrote: >> >>> Is there a canonical approach, or is it something like: >>> >>> $dt->add( days => 1 )->truncate( to => 'day' )->subtract( seconds => 1 ); >> >> That should work fine, _but_ if you're not in the floating timezone that >> could land you on "second 60" every once in a while, and your dbms may >> not like it. > > Interesting. It's a valid time, though, correct? Sure, but if your dbms is not leap-second aware, it may not agree. -dave /*============================================================ http://VegGuide.org http://blog.urth.org Your guide to all that's veg House Absolute(ly Pointless) ============================================================*/