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 |
|
eem_2055
Yak Posting Veteran
69 Posts |
 Posted - 2007-11-16 : 01:40:31
|
| hi guys how can I change this format date|amount02/25/07| 00.0002/26/07| 00.00To date|amount02/25/07| 0.0002/26/07| 0.00thanks! |
|
|
elancaster
A very urgent SQL Yakette
1208 Posts |
Posted - 2007-11-16 : 02:39:29
|
| am assuming AMOUNT is currently stored as a string?you need to cast it as a number. something like...cast(amount as decimal(5,2))Em |
 |
|
|
eem_2055
Yak Posting Veteran
69 Posts |
Posted - 2007-11-16 : 04:04:44
|
| Thanks a lot! |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-11-19 : 01:48:59
|
| what is the datatype of date? Make sure you used DATETIME datatypeMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
converting data format