Decoding timestamp field in SCX

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Decoding timestamp field in SCX

Message

From

02/09/1999 12:07:07

Sylvain Larin
Montréal, Quebec, Canada

02/09/1999 11:07:40

Chris Vesper
BBL Systems, Inc.
Georgia, United States

General information

Forum:

Visual FoxPro

Category:

Forms & Form designer

Title:

Re: Decoding timestamp field in SCX

Miscellaneous

Thread ID:

00260633

Message ID:

00260653

Views:

Try this:

LPARAMETERS tnStamp

RETURN IIF(tnStamp = 0,;
   {//::},
   DateTime(1980 + BitAnd(BitRShift(tnStamp, 25), 63),
      BitAnd(BitRShift(tnStamp, 21), 15),;
      BitAnd(BitRShift(tnStamp, 16), 31),;
      BitAnd(BitRShift(tnStamp, 11), 31),;
      BitAnd(BitRShift(tnStamp, 5), 63),;
      BitAnd(BitLShift(tnStamp, 1), 15)))

HTH

>I would like to convert the value of the timestamp field in the SCX to a date/time value. Does anyone know how the timestamp is encoded?

Map

View

Click here to load this message in the networking platform