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 |
learning_grsql
Posting Yak Master
230 Posts |
Posted - 2014-03-07 : 01:34:07
|
I have a time column in the below format in a table. I want to change it to "hhmm" format. How I can do that?12:3513:4117:2306:35I want output1235134117230635 |
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2014-03-07 : 01:46:24
|
what is the data type of your column ? KH[spoiler]Time is always against us[/spoiler] |
|
|
learning_grsql
Posting Yak Master
230 Posts |
Posted - 2014-03-07 : 02:16:41
|
varchar |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2014-03-07 : 02:22:00
|
[code]stuff ( col , 3, 1, '' )[/code] KH[spoiler]Time is always against us[/spoiler] |
|
|
learning_grsql
Posting Yak Master
230 Posts |
Posted - 2014-03-07 : 03:43:28
|
thanks, is it possible to do this with any time function? I'm asking this because I may need to change this to another time format later. |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2014-03-10 : 05:02:26
|
quote: Originally posted by learning_grsql thanks, is it possible to do this with any time function? I'm asking this because I may need to change this to another time format later.
It is not possibleMadhivananFailing to plan is Planning to fail |
|
|
|
|
|