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 p
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 s
the blanket any
longer...""
> -Original Message-
> From: sqlite-users-bounces 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 mail
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 equivale
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 anythin
> 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:
>
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, 'unixe
8 matches
Mail list logo