Date Time String Transformation sample mssql
-
here's my query select t.date_value, start_time,end_time,upper(r.last_name)+', '+r.first_name teacher_name, datediff(hh,t.start_time,t.end_time)*t.rate total_rate,t.remarks FROM dbo.ttcpCustomizedSchedule t left outer join dbo.ResourcePersons r on r.teacher_id=t.teacher_id where t.tload_id = 5724 order by date_value i want to make the start_time and endtime using a string format of: "hh:mm tt" please help me... i am using mssql server 2000
-
here's my query select t.date_value, start_time,end_time,upper(r.last_name)+', '+r.first_name teacher_name, datediff(hh,t.start_time,t.end_time)*t.rate total_rate,t.remarks FROM dbo.ttcpCustomizedSchedule t left outer join dbo.ResourcePersons r on r.teacher_id=t.teacher_id where t.tload_id = 5724 order by date_value i want to make the start_time and endtime using a string format of: "hh:mm tt" please help me... i am using mssql server 2000
Try:
Substring(convert(varchar, StartTime, 100), 13, 8) -
Try:
Substring(convert(varchar, StartTime, 100), 13, 8)thnx!