Post reply

change type

  • June 23, 2005 at 7:04 pm

    #89852

    how do I change the type in a stored procedure from varchar to datetime? I need my results to be in datetime format for one page so I can format it the way I need.

    I can't change the type in the database itself.

  • June 23, 2005 at 9:40 pm

    #568166

    Declare @StringDate Varchar (50),

    @Date Datetime

    Set @StringDate = '15 Jan 2005'

    Select @Date = Convert(Datetime, @StringDate)

    Select @StringDate, @Date

  • June 23, 2005 at 9:59 pm

    #568169

    I don't understand your reply. Here is what I have so far for my stored procedure.

    (

    @UserID Int

    )

    AS

    SELECT User_ID, Position_ID, Company_Name, Position_Title, Start_Date, End_Date

    FROM dbo.MySurvey_Positions

    WHERE User_ID = @UserID

    I need to change End_Date from varchar to datetime

  • June 23, 2005 at 10:05 pm

    #568171

    SELECT User_ID, Position_ID, Company_Name, Position_Title, Start_Date, Convert(DateTime,End_Date) as End_Date

    FROM dbo.MySurvey_Positions

    WHERE User_ID = @userid

  • June 23, 2005 at 10:41 pm

    #568173

    Remi - Curtis may mean using "alter procedure"....since he says he cannot change it directly in the database!

    Of course I could be totally wrong (not surprising that....)







    **ASCII stupid question, get a stupid ANSI !!!**

  • June 23, 2005 at 10:43 pm

    #568175

    Maybe...not sure anymore.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply