Re: Dates after year 2038

From: Stuart Toll (stuart.toll_at_online.nospam)
Date: 11/10/04 

Date: Wed, 10 Nov 2004 01:55:02 -0800

Thanks for your message. Please let me know if you find any additional
information otherwise I might have to raise a support call with MS.

"Michel Walsh" wrote:

> Hi,
>
>
> I am surprised by the article. 2038 sounds like a limitation on some
> system that use long integers to store time in milliseconds since, if I
> remember well, sometime close to 1970. That long integer would get an
> overflow past 2038, and would turn in the negative. Furthermore, Jet 4.0 is
> not aware of the Gregorian reform, so it should also be limited to year
> 1753, not back to year 200.
>
>
> I try to get more details and post back if anything relevant about it.
> but seems,
>
> either the article is wrong
> either Jet 4.0 untimely uses a C library where time is stored in
> msec since 1970
> either only "some" exportation functionalities are implied,not
> internal working
>
>
> Hoping it may help
> Vanderghast, Access MVP
>
>
> "Stuart Toll" <stuart.toll@online.nospam> wrote in message
> news:8C3ACD03-3527-461A-B5D1-5DDE680B432B@microsoft.com...
> > According to the knowledge base article at
> > http://support.microsoft.com/default.aspx?scid=kb;EN-US;240246 some Jet 4
> > functions do not support dates after the year 2038. Does anyone have any
> > additional information about these limitations, specifically which SQL
> > commands it affects.
> >
> > Thanks
>
>
>

Relevant Pages

  • Re: Does anyone have this Hotfix?
    ... Not sure what the "Knowledge Base article number". ... >>> A supported hotfix is now available from Microsoft, ... >>> To resolve this problem immediately, contact Microsoft Product Support ...
    (microsoft.public.windows.mediacenter)
  • RE: WPF: Layout recursion reached allowed limit to avoid stack overflow: 255
    ... Each node will be composed of a few nested visuals meaning that the total ... We can see the layout recursion limitation from ... Microsoft Online Community Support ... where an initial response from the community or a Microsoft Support ...
    (microsoft.public.dotnet.framework)
  • Re: AltairZ80 simulator updated
    ... > not a limitation of MS-DOS, but rather a limitation of the PC ... Basic memory management ... support in DOS had most of what it needed to support 1 MB, ... by the high memory support of later years. ...
    (comp.os.cpm)
  • RE: 7.5 Gig File Wont Download
    ... serve file larger than 4GB: ... The limitation doesn't exist on IIS6 but you are using IE, ... You Cannot Download Files That Are 2 GB or Larger ... Microsoft Online Support ...
    (microsoft.public.inetserver.iis)
  • Re: [PATCH 0/2] range-bw : Another I/O scheduling policy of dm-ioband (v1)
    ... and limitation of unnecessary I/O bandwidth at the same time. ... mode is to support only limitation. ... I will re-consider about supporting the unified interfaces as you pointed ...
    (Linux-Kernel)