Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Gerald30
Yak Posting Veteran
62 Posts |
 Posted - 2013-07-06 : 00:03:48
|
| Hello,Good Day.Kindly Help me Please....How can I convert a 4 digit Integer into Time(HH:mm) ?Thanks in advance. |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2013-07-06 : 00:09:16
|
how does the 4 digits integer looks like ? and what time does it represent ?
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
Gerald30
Yak Posting Veteran
62 Posts |
Posted - 2013-07-06 : 00:13:33
|
| ah it represent 24hr time.Samples are 1930 and 0705 |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2013-07-06 : 00:33:09
|
[code]stuff(convert(varchar(10), 1930), 3, 0, ':')[/code]
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
Gerald30
Yak Posting Veteran
62 Posts |
Posted - 2013-07-06 : 00:39:55
|
Thanks a Lot Sir... |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2013-07-06 : 01:48:01
|
welcome
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
|
|
|
Convert Number to Time