On Sun, 13 Dec 2015 20:11:32 -0700
Scott Robison wrote:
> > It's not fixed, although gacial progress is being made. Even though
> > we've had the TZ database & Posix datetime functions since 1986, 30
> > years later we're still struggling with it, and not only on Windows.
>
> The problem would
>...
>We need a metric calendar. I propose redefining the second so that a day is
>100,000 seconds long... ;)
>
>--
>Scott Robison
And while we are already redefining the fundamental constants of measuring, we
could redefine the meter to be exactly three feet and the kilogram to be
exactly two
On Sun, Dec 13, 2015 at 6:44 PM, Keith Medcalf wrote:
> We have been doing daylight savings changes to and from twice a year for
> as long as I remember (that is more than 100 times) and we still cannot
> manage to do it properly. Leap years have been occurring for a long time
> and somehow we
nces at mailinglists.sqlite.org [mailto:sqlite-users-
> bounces at mailinglists.sqlite.org] On Behalf Of James K. Lowden
> Sent: Sunday, 13 December, 2015 19:00
> To: sqlite-users at mailinglists.sqlite.org
> Subject: Re: [sqlite] Bug with DATETIME('localtime')
>
> On Thu,
On Sun, Dec 13, 2015 at 5:00 PM, James K. Lowden
wrote:
> On Thu, 10 Dec 2015 06:34:44 -0700
> "Keith Medcalf" wrote:
>
> > The only way to convert datetime data on windows is to use a
> > third-party package that does it properly, or write it yourself.
> > Using the WinAPI functions is
On Thu, 10 Dec 2015 06:34:44 -0700
"Keith Medcalf" wrote:
> The only way to convert datetime data on windows is to use a
> third-party package that does it properly, or write it yourself.
> Using the WinAPI functions is equivalent to "writing it yourself"
> because they do not actually do
:49
> To: sqlite-users at mailinglists.sqlite.org
> Subject: [sqlite] Bug with DATETIME('localtime')
>
> Hi,
> I've found a bug with using 'localtime' in functions DATETIME(), DATE(),
> TIME().
>
> Platform: Windows 7.
> Steps to reproduce:
> 1. Set your system time z
Hi,
I've found a bug with using 'localtime' in functions DATETIME(), DATE(),
TIME().
Platform: Windows 7.
Steps to reproduce:
1. Set your system time zone as "Russia Time Zone 2, (UTC+03:00) Moscow,
St. Petersburg, Volgograd)".
2. Execute the following script:
SELECT DATETIME(1414267200,
8 matches
Mail list logo