Member Avatar for krunal1986

Hello,

I have field in db table which have real datatype in SQL 2005. I want to convert it into time (HH:MM) format and add to another time.

ex:
0.3 (convert it to 00:30) and want to add into 17:45 so i can get 18:15
0.45(convert it to 00:45) and want to add into 17:45 so i can get 18:30
1(convert it to 01:00) and want to add into 17:45 so i can get 18:45

Thanks.

  • 2 Contributors
  • 2 Replies
  • 132 Views
  • 2 Hours Discussion Span
  • Latest Post Latest Post by krunal1986
Member Avatar for pritaeas

Do you want to do this with just a query, or are you converting in .NET?

Member Avatar for krunal1986

I want whichever is best. if we can do with SQL query then it's good. I stuck here.

Edited by krunal1986
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.