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 |
|
scelamko
Constraint Violating Yak Guru
309 Posts |
 Posted - 2005-04-01 : 10:40:06
|
| guysI have date conversion issue here I have datetime datatype field in the following format '1998-07-01 00:00:00.000' I want to covert it format '07/01/1998', i have tried using the function'convert(datetime, columnname, 101)'but it doesnt seem to work. Any suggestions and work arounds will be very helpfulThanks |
|
|
jparker
Posting Yak Master
118 Posts |
Posted - 2005-04-01 : 10:55:05
|
| Are you wanting to do the conversion within the sql statement or within a scripting language such as ASP or PHP? |
 |
|
|
rfrancisco
Yak Posting Veteran
95 Posts |
Posted - 2005-04-01 : 11:03:43
|
| Try CONVERT(VARCHAR(10), columnname, 101). |
|
|
|
|
|
|
date formats and conversions