<div>
i am not sure aobut style param <br />
but this may help<br />
select convert(varchar(2), DATEPART(hour, getdate())) + convert(varchar(2), DATEPART(minute, getdate()))
</div>


i am not sure aobut style param
but this may help
select convert(varchar(2), DATEPART(hour, getdate())) + convert(varchar(2), DATEPART(minute, getdate()))

<div>
here format options in detail<br />
<a href="http://doc.ddart.net/mssql/sql70/ca-co_1.htm" rel="ugc">http://doc.ddart.net/mssql/sql70/ca-co_1.htm</a>
</div>


here format options in detail
http://doc.ddart.net/mssql/sql70/ca-co_1.htm [http://doc.ddart.net/mssql/sql70/ca-co_1.htm]

<div>
convert(varchar(2), DATEPART(hour, getdate())) + convert(varchar(2), DATEPART(minute, getdate()))<br />
<br />
This works for a time like 10:30. &nbsp;The output is 1030 but if the time is 8:00:00 the output is 80 so I'm missing the leading 0 before the 8 and the second 0 for the minute.
</div>


convert(varchar(2), DATEPART(hour, getdate())) + convert(varchar(2), DATEPART(minute, getdate()))

This works for a time like 10:30.  The output is 1030 but if the time is 8:00:00 the output is 80 so I'm missing the leading 0 before the 8 and the second 0 for the minute.

<div>
It would have easier to understand if you referenced by field in the solution. &nbsp;
</div>


It would have easier to understand if you referenced by field in the solution.  

<div>
<div class="content wysiwyg-content">
I'm extracting data from sql server and need to output the data in a specific order and format. &nbsp;The field I'm having trouble with is defined in sql server as a datetime field (8). &nbsp;My extract requires the time to be formatted as a numeric 4 chars, as in military time with leading zeros, so 8:00 should appear as 0800 &nbsp; Here is my current statement:<br />
<br />
Convert(varchar(10),dbo.ca<wbr />lendar.sta<wbr />rt_time,10<wbr />8) as BegTime<br />
which returns 08:00:00<br />
<br />
I can't figure out if there is a style parameter that will give me what I need.
</div>
</div>


I'm extracting data from sql server and need to output the data in a specific order and format.  The field I'm having trouble with is defined in sql server as a datetime field (8).  My extract requires the time to be formatted as a numeric 4 chars, as in military time with leading zeros, so 8:00 should appear as 0800   Here is my current statement:

Convert(varchar(10),dbo.calendar.start_time,108) as BegTime
which returns 08:00:00

I can't figure out if there is a style parameter that will give me what I need.

Format output of time from a datetime field

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.