Re: Date Stamp


Craig Hornish wrote:
If your table field name is "Date" or "Time"
Be sure to use [ ] brackets around the field names in queries and vba code
when referring to fields that are using these reserved words as the column
header so that Access can distinguish between your table field name and
the
built-in function.

Better yet - Change it to DateStamp or TimeStamp - for clarity (BirthDate,
HireDate etc.) and the issue about reserved words.

....and the issue about reserved words remains.

TIMESTAMP is a standard SQL data type, synonymous with Access/Jet's
DATETIME type. Acess/Jet's big sister, SQL Server, has a TIMESTAMP
9so-called) data type. Hence, TIMESTAMP is a reserved word in Jet 4.0,
SQL Server, SQL-92, SQL-99, SQL-2003 and ODBC.

Jamie.

--

.

Relevant Pages

  • 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: Convert help needed desperately
    ... overflow error converting expression to data type datetime. ... Is my sql server hosed???? ... > the timestamp data type. ...
    (microsoft.public.sqlserver.programming)
  • Re: How to create a timestamp?
    ... SQL Server's Timestamp is a SQL Server specific data type that is simply an ... shows you the SQL Server data type along with the SQL Client equivalent ...
    (microsoft.public.dotnet.languages.vb)
  • Re: How to handle concurrency issue with better performance?
    ... Hitchhiker's Guide to Visual Studio and SQL Server ... Then for timestamp, it will be unique? ... Collisions occur because your design permits ... select command). ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: How to handle concurrency issue with better performance?
    ... Then for timestamp, it will be unique? ... Hitchhiker's Guide to Visual Studio and SQL Server ... We all work with relational database designs and more ... select command). ...
    (microsoft.public.dotnet.framework.adonet)
Loading