Skip to main content
How to convert string time to 24 Hours format in SQL.

Declare @Test datetime
Select  @Test=CONVERT(datetime, '06:59PM' , 120)
Select Cast(@Test as time(0))

Comments

Post a Comment

Popular posts from this blog

How to download partial view content using c#? private static string CallApplicationControllerForSnapshotHtml(Guid subscriberId, int duration, long? subscriberUserId, string conString)         {             string myUrl = string.Format(ServiceConfigurationHelper.GetAppSettingValue("GetHtmlContentUrl") + "?subscriberId={0}&duration={1}&SubscriberUserId={2}&conString={3}", subscriberId, duration, subscriberUserId, conString);             WebClient wc = new WebClient();             string requestResult = wc.DownloadString(myUrl);             return requestResult;         }
Post a Comment
Read more