Buy Questpond's video subscriptions on huge discount.
DotNetFunda.com
Online: 1926
Home > Codes >

Format Time From HHMM to HH:MM using Stuff function.

Vishalneeraj-24503
Posted by Vishalneeraj-24503 under Sql Server category on | Points: 40 | Views : 737
Post Code | Search Codes | Code Home  
Write below query:-
DECLARE @Time VARCHAR(10);
SET @Time = '1145'

SELECT STUFF(@Time,3,0,':') AS [HH:MM]


Output
11:45
Alert Moderator 
Bookmark It

Comments or Responses

Login to post response

Latest Code Snipptes