On 5 Mar, 20:09, "machina" <mm(at)home.pl> wrote:
> Hi,
>
> I would like to convert real data type to datetime type. Example:
> I have a real data type which is: 23,613456 (23 hours and 0,613456). I
> would like to have it in hh:mm:ss format. How to do this? Can I use
> convert/cas function?
>
> Thanks for help
> Rgds
> Mario

>> I would like to convert real data type to datetime type. Example: I have
>> a real data type which is: 23,613456 (23 hours and 0,613456).

"David Portas" <REMOVE_BEFORE_REPLYING_dportas@acm.org> wrote in message
news:1173129084.319185.233820@j27g2000cwj.googlegroups.com...
> DECLARE @r REAL;
> SET @r = 23.613456;
> SELECT DATEADD(MS,@r*3600000,'20070305');
>
> --
> David Portas, SQL Server MVP
>
> Whenever possible please post enough code to reproduce your problem.
> Including CREATE TABLE and INSERT statements usually helps.
> State what version of SQL Server you are using and specify the content
> of any error messages.
>
> SQL Server Books Online:
> http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
> --
>

"Raymond D'Anjou" <thisisatest@gotyou.com> wrote in message
news:uLzabx2XHHA.1240@TK2MSFTNGP04.phx.gbl...
> Or for something a bit different:
> select cast('20070305' as datetime) + @r*24
>
> "David Portas" <REMOVE_BEFORE_REPLYING_dportas@acm.org> wrote in message
> news:1173129084.319185.233820@j27g2000cwj.googlegroups.com...
>> DECLARE @r REAL;
>> SET @r = 23.613456;
>> SELECT DATEADD(MS,@r*3600000,'20070305');
>>
>> --
>> David Portas, SQL Server MVP
>>
>> Whenever possible please post enough code to reproduce your problem.
>> Including CREATE TABLE and INSERT statements usually helps.
>> State what version of SQL Server you are using and specify the content
>> of any error messages.
>>
>> SQL Server Books Online:
>> http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
>> --
>>
>
>

"Anith Sen" <anith@bizdatasolutions.com> wrote in message
news:ejfy8h2XHHA.4220@TK2MSFTNGP03.phx.gbl...
>>> I would like to convert real data type to datetime type. Example: I have
>>> a real data type which is: 23,613456 (23 hours and 0,613456).
>
> What is 0,613456? Seconds or minutes?
>
> --
> Anith

> I would like to convert real data type to datetime type. Example:
> I have a real data type which is: 23,613456 (23 hours and 0,613456). I
> would like to have it in hh:mm:ss format. How to do this? Can I use
> convert/cas function?

"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
news:Xns98EB1A91A578Yazorman@127.0.0.1...
> machina (mm(at)home.pl) writes:
>> I would like to convert real data type to datetime type. Example:
>> I have a real data type which is: 23,613456 (23 hours and 0,613456). I
>> would like to have it in hh:mm:ss format. How to do this? Can I use
>> convert/cas function?
>
> And next time you feel compelled to ask the same question in two
> newsgroups,
> please cross-post, so people don't waste time on answering things that
> already have been answered. For the record, here is what I posted in
> comp.databases.ms-sqlserver:
>
> declare @d real
> select @d = 23.613456
> select @d = @d /24
> select convert(char(8), convert(datetime, @d), 108)
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se