Re: Convert help needed desperately
From: CL (cl_at_mail)
Date: 05/14/04
- Next message: Steve: "Re: use And or Where to filter join table in Update statement?"
- Previous message: Tom Moreau: "Re: Convert help needed desperately"
- In reply to: Tom Moreau: "Re: Convert help needed desperately"
- Next in thread: Tom Moreau: "Re: Convert help needed desperately"
- Reply: Tom Moreau: "Re: Convert help needed desperately"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 13 May 2004 19:22:57 -0500
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
> >
> >
>
>
- Next message: Steve: "Re: use And or Where to filter join table in Update statement?"
- Previous message: Tom Moreau: "Re: Convert help needed desperately"
- In reply to: Tom Moreau: "Re: Convert help needed desperately"
- Next in thread: Tom Moreau: "Re: Convert help needed desperately"
- Reply: Tom Moreau: "Re: Convert help needed desperately"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
