Home Forums SQL Server 2008 SQL Server Newbies Stored procedure to split and insert values into tables RE: Stored procedure to split and insert values into tables

  • October 24, 2012 at 3:42 am

    #1552189

    arthi.anan (10/24/2012)

    I need to convert dt_of_birth [varchar] (15) which is in the format DD-Mon-YYYY to DD/MM/YYYY

    So how do i give this in the stored procedure?

    You can use the Date and time styles section on following link of msdn

    http://msdn.microsoft.com/en-us/library/ms187928.aspx

    Regards

    IgorMi

    Igor Micev,My blog: www.igormicev.com