News
I have the results of a system sproc that give me the date and time (as seperate fields) something ran.So I have the time last run as: 180001 I need to convert that to something more like 18:00:01 ...
Use the "CONVERT" statement to get a date object and convert it into a string of characters:sql>SELECT purchase_date FROM Purchases WHERE (SELECT CONVERT ()) Fill the "CONVERT" function with the ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback