Re: Difference between two dates and times

From: Jamie Collins (jamiecollins_at_xsmail.com)
Date: 10/21/04 

Date: 21 Oct 2004 06:46:37 -0700

John Vinson <jvinson@STOP_SPAM.WysardOfInfo.com> wrote ...

> > I have two columns in a table. One is START_TIME the other is END_TIME and
> > they are both TIMESTAMP data types

> Are these SQL Server tables? Access (JET) tables have a Date/Time
> datatype but do not have a Timestamp.
>
> Take a look at the DateDiff() function in the VBA help. I believe it
> will work with TIMESTAMP values as well as Date/Time values but I'm
> not absolutely certain!

Does Jet have a TIMESTAMP data type? Yes and no <g>:

  CREATE TABLE QuartzClocks (
    MyKeyCol INTEGER NOT NULL,
    start_date TIMESTAMP DEFAULT NOW() NOT NULL,
    end_date TIMESTAMP NULL
  );

However, TIMESTAMP merely maps to Jet's DATETIME data type.

Jamie. 

--

Relevant Pages

  • RE: date time stamp in sql
    ... Some further information on the Timestamp type in SQLServer, ... The Transact-SQL timestamp data type is not the same as the timestamp data ... So I think in SQLServer, if we want to store date/time data, we should use ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Passing Timestamp value to sql server
    ... the following example cast the timestamp to a data type of datetime: ... You can also cast it to another type. ... >I still need to pass the value back to the server. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Data Types
    ... > moved to SQL Server and I don't know the best newsgroups yet. ... > Does a Unique Identifier data type take up less storage space than a 32 ... A uniqueidentifier uses 16 bytes. ... but I'm looking at the data types and think that the TimeStamp ...
    (microsoft.public.sqlserver.programming)
  • Re: Date Stamp
    ... HireDate etc.) and the issue about reserved words. ... TIMESTAMP is a standard SQL data type, ... Acess/Jet's big sister, SQL Server, has a TIMESTAMP ...
    (microsoft.public.access.tablesdbdesign)
  • RE: :Oracle V 1.16 & Oracle type 187 not explicitly supported
    ... DATE data type which stores date+time. ... functionality of Oracle. ... the timestamp field below that the error is thrown ...
    (perl.dbi.users)