convert date and time string to yy/mm/dd hh:mm:ss

DECLARE @FormatedDateTime varchar(36)
DECLARE @YourDate char(10)
DECLARE @YourTime char(10)

SELECT @YourDate = '101114'
SELECT @YourTime = '162941'

SELECT @FormatedDateTime = convert(varchar, convert(datetime, @YourDate), 111)
    + ' ' + substring(@YourTime, 1, 2)
    + ':' + substring(@YourTime, 3, 2)
    + ':' + substring(@YourTime, 5, 2)

SELECT FormattedDateTime = @FormatedDateTime

using System;
using System.Globalization;
class Program
{
    static void Main()
    {
        string dateString = "Mon 16 Jun 8:30 AM 2008"; 
        string format = "ddd dd MMM h:mm tt yyyy";
        DateTime dateTime = DateTime.ParseExact(dateString, format,
            CultureInfo.InvariantCulture);
        Console.WriteLine(dateTime);
    }
}