Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Re: Parsing a Timestamp

Discussion in 'Information Technology' started by Scottie, Jul 28, 2006.

  1. Scottie

    Scottie
    Expand Collapse
    Guest

    The time field is an Access date-time data type.
     
  2. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On 9 May 2006 01:44:34 -0700, "Scottie" <sstrachan@ups.com> wrote:

    >The time field is an Access date-time data type.


    A Date/Time value is stored as a Double Float number, a count of days
    and fractions of a day since midnight, December 30, 1899. E.g.

    ?Now;CDbl(Now)
    5/9/2006 10:40:31 AM 38846.4448032407


    John W. Vinson[MVP]
     

Share This Page