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:34:50 -0400

No. The timestamp column is useless to you. Drop the column. You can add
a new column of datatype datetime and populate it with getdate(). 

-- 
   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:usBP7kUOEHA.3420@TK2MSFTNGP11.phx.gbl...
I tried this already as well - this is the Error I get
'Customer' table
- Unable to modify table.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Arithmetic
overflow error converting expression to data type datetime.
[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been
terminated.
Is my sql server hosed????
"Tom Moreau" <tom@dont.spam.me.cips.ca> wrote in message
news:#q8WegUOEHA.892@TK2MSFTNGP09.phx.gbl...
> 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: DayLight Saving woes
    ... I've just been reading the SQL Server documentation again Aaron, ... If it stores datetime and smalldatetime values as "timestamps" (i.e. ... IMHO, a true binary "timestamp" data-type is more efficient, immune from ...
    (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: between dates with no time consideration
    ... Columnist, SQL Server Professional ... just the range doesnt declare @start as datetime ... "Tom Moreau" wrote in message ... > "Tom Moreau" wrote in message ...
    (microsoft.public.sqlserver.programming)
  • 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