Tuesday, March 27, 2012

Convert

Hi everyone,
How can I convert 18:00:00 to 18:00LEFT(18:00:00,5)
OR if it is some kind of datetime column you could take the single parts
with
Datepart(hh,Datecol)...
HTH, Jens Suessmeyer.
"jerry" <goercharnajay@.hotmail.com> schrieb im Newsbeitrag
news:ulhHb4ZUFHA.2444@.TK2MSFTNGP10.phx.gbl...
> Hi everyone,
> How can I convert 18:00:00 to 18:00
>
>|||Propably, if you use it in a query you could write your own function for
that.
"jerry" <goercharnajay@.hotmail.com> schrieb im Newsbeitrag
news:ulhHb4ZUFHA.2444@.TK2MSFTNGP10.phx.gbl...
> Hi everyone,
> How can I convert 18:00:00 to 18:00
>
>

No comments:

Post a Comment