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)
============================================================*/
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.