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 |
|
ranjeetsingh_6
Posting Yak Master
125 Posts |
 Posted - 2007-12-25 : 04:57:57
|
| HiI have a table, name is history and column is Hdate(its DataType is Text). Date stored into Hdate column like thisHdate-------------------2007010220070103NULL20070104aaaaaa20070105''20070106---------------------I want output like belowHdate-------------------2007010220070103200701042007010520070106---------------------means i want that value which can be converted into "yyyy-mm-dd" formate.Ranjeet Kumar Singh |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2007-12-25 : 13:02:20
|
| Cross post. I've answered it here[url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=94671[/url] |
 |
|
|
|
|
|
check that a column value is date or not