RE: Compare two timestamps from MS access DB

let's make this more clear.

Can we convert timestamp to an int for further calculation?

Thanks. -Dale

"dale zhang" wrote:

> Hi,
>
> I have a MS access DB with some users signed in at different dates.
>
> I want to check the DB daily to compare everyone’s timestamp against current
> date to find who’s in our DB for more than two weeks. How could I do this?
>
> Can I run a thread every day (let’s say 8pm) in C# to read everyone’s time
> and compare it against current time (how to do?)?
>
> Or write a script run against ms access manually or automatically?
>
> Any suggestions?
>
> Thanks. -Dale
>
.

Relevant Pages

  • RE: Compare two timestamps from MS access DB
    ... thank you for everyone who spent ... "dale zhang" wrote: ... > Can we convert timestamp to an int for further calculation? ... >> and compare it against current time? ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: SQL Server via MS Access
    ... > I am able to modify some of the records in Access, ... You need to add a TIMESTAMP column to each SQL table, ... this, by default, it codes the update to compare every field. ... Access can simply check using the TIMESTAMP column. ...
    (microsoft.public.windows.server.sbs)
  • Re: HELP! compare two SQL timestamps in C# byte arrays
    ... The inherent 'timestamp' for a record isn't based on time and as such to compare as being larger / ... The problem is I am not testing for Equality. ... >> how do convert\manipulate the arrays to something I can compare. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: comparing PE files with CRC/checksum
    ... >>My application requires the ability to compare two files using a CRC32 ... If two object files differ only in their timestamp they are ... digital fingerprint without ever modifying the binary file. ... But the bottom line is that I consider two object files identical ...
    (microsoft.public.win32.programmer.kernel)
  • Re: Shorter checksum than MD5
    ... > How about putting a timestamp in each record, ... > compare the records that have been updated since the last period ... Every night I would 'SELECT' all checksums ... cursor.execute("SELECT ID, md5sum, 0 FROM ARTIKEL;") ...
    (comp.lang.python)