<div>
SELECT CONVERT(VARCHAR(10), HourTimeFrom, 100) AS HourTimeFrom,<br />
&nbsp; &nbsp;CONVERT(VARCHAR(10), HourTimeTo, 100) AS HourTimeTo<br />
FROM tblOrgHours
</div>


SELECT CONVERT(VARCHAR(10), HourTimeFrom, 100) AS HourTimeFrom,
   CONVERT(VARCHAR(10), HourTimeTo, 100) AS HourTimeTo
FROM tblOrgHours

<div>
Or in Excel format those columns with the &quot;h:mm AM/PM&quot; custom format. That might make it easier to perform calculations against those time values (instead of converting it into text).
</div>


Or in Excel format those columns with the "h:mm AM/PM" custom format. That might make it easier to perform calculations against those time values (instead of converting it into text).

<div>
Russell,<br />
<br />
I tried that route and it still shows up in the funky numbers
</div>


Russell,

I tried that route and it still shows up in the funky numbers

<div>
Using this method<br />
SELECT CONVERT(VARCHAR(10), HourTimeFrom, 100) AS HourTimeFrom,<br />
&nbsp; &nbsp;CONVERT(VARCHAR(10), HourTimeTo, 100) AS HourTimeTo<br />
FROM tblOrgHours<br />
<br />
Does it take up much more processing time? &nbsp;If so, is there a better way to do this? &nbsp;<br />
<br />
Is there a DataType that addresses this issue?
</div>


Using this method
SELECT CONVERT(VARCHAR(10), HourTimeFrom, 100) AS HourTimeFrom,
   CONVERT(VARCHAR(10), HourTimeTo, 100) AS HourTimeTo
FROM tblOrgHours

Does it take up much more processing time?  If so, is there a better way to do this?  

Is there a DataType that addresses this issue?

<div>
<div class="content wysiwyg-content">
I am placing time values into my excel sheet in vb6<br />
<br />
The time that I have in my DB looks like the following: &nbsp;DataType Time(7)<br />
<br />
HourTimeFrom &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;HourTimeTo<br />
13:00:00.0000000 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;14:00:00.0000000<br />
09:00:00.0000000 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;10:00:00.0000000<br />
09:00:00.0000000 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;10:00:00.0000000<br />
<br />
I am using the following query<br />
<br />
SELECT r.RegID,h.HourTimeFrom,h.H<wbr />ourTimeTo from tblOrgHours<br />
<br />
I would like the output to return a standard time format or 1:00 PM
</div>
</div>


I am placing time values into my excel sheet in vb6

The time that I have in my DB looks like the following:  DataType Time(7)

HourTimeFrom	HourTimeTo
13:00:00.0000000	14:00:00.0000000
09:00:00.0000000	10:00:00.0000000
09:00:00.0000000	10:00:00.0000000

I am using the following query

SELECT r.RegID,h.HourTimeFrom,h.HourTimeTo from tblOrgHours

I would like the output to return a standard time format or 1:00 PM

display in time in a normal format

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.