Convert help needed desperately

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: CL (cl_at_mail)
Date: 05/13/04 

Date: Thu, 13 May 2004 18:15:06 -0500

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: [PHP] PHP and mySQL dates
    ... single event for example, the data is entered into the events table, ... Now it sounds like you are inserting even MORE entries into another ... between UNIX and mySQL timestamp values. ... type of data -- DATE, not DATETIME, TIMESTAMP, etc. ...
    (php.general)
  • Need Help - Desperately
    ... 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 ...
    (microsoft.public.win32.programmer.messaging)
  • Re: Please advise on approach
    ... has direct bearing on the issues and the context is difficult to communicate ... > of the term timestamp - it does not refer to the sql data type in this ... rather to the datetime at which the source produced the data - ... I'm only interested in it differentiating between records ...
    (microsoft.public.sqlserver.server)
  • 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: Error: Executing Stored Procedures-- Cannot Pass TimeStamp Values From sqlCommand Object Parame
    ... The @RowV Values when it reaches the stored procedure on SQL server always gets reset to 0x00 No matter what value I set it to. ... I am using timestamps to determine if the row has been updated on the server before I apply the new updates. ... @ProviderID smallint, ... @RowOut timestamp OUTPUT ...
    (microsoft.public.dotnet.framework.adonet)