Re: Convert help needed desperately

From: Tom Moreau (tom_at_dont.spam.me.cips.ca)
Date: 05/14/04 

Date: Thu, 13 May 2004 20:12:11 -0400

Don't use timestamp. Change the column datatype to datetime and simply set
the value = getdate(). Timestamp - now known as rowversion - is not used
for anything to do with time. 

-- 
   Tom
----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON   Canada
www.pinnaclepublishing.com/sql
.
"CL" <cl@mail> wrote in message
news:uT8y0cUOEHA.3044@TK2MSFTNGP10.phx.gbl...
It is just getting the current system date and placing it a field that is of
the timestamp data type.  I'm trying to do an update query and this is a
required field - and does not accept null
"Tom Moreau" <tom@dont.spam.me.cips.ca> wrote in message
news:Own$yBUOEHA.3044@TK2MSFTNGP10.phx.gbl...
> Unlike its name, timestamp has absolutely nothing to do with time.  What
is
> your actual business requirement?
>
> --
>    Tom
>
> ----------------------------------------------------
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON   Canada
> www.pinnaclepublishing.com/sql
> .
> "CL" <cl@mail> wrote in message
news:eor1A$TOEHA.556@tk2msftngp13.phx.gbl...
> I have a stored procedure that is throwing an error 291 when I'm trying to
> convert datetime to a timestamp.
>
> The table I am inserting into needs to have a timestamp My code in
question
> looks like this:
>
> ,   Convert(timestamp(8), getdate()) as upsize_ts
>
> Can any one help to see what I am doing wrong????
>
> CL
>
>

Relevant Pages

  • 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: Convert help needed desperately
    ... The timestamp column is useless to you. ... a new column of datatype datetime and populate it with getdate. ... Columnist, SQL Server Professional ... > "Tom Moreau" wrote in message ...
    (microsoft.public.sqlserver.programming)
  • 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)
  • Re: How to handle concurrency issue with better performance?
    ... Keep in mind that a timestamp column does not store a date/time value. ... 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)