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 |
|
anjan
Starting Member
21 Posts |
 Posted - 2005-09-25 : 11:59:01
|
| how to get date format in the following format.dd/mmm/yyyy hh:mm:ss AM/PMThere is no code in convert function to get this particular format. |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-09-25 : 13:00:45
|
do this in your front end. sql server isn't meant for formating data.Go with the flow & have fun! Else fight the flow  |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-09-26 : 00:26:38
|
| Where do you want to use this format?In your Application, you can format it to the way you wantIf you want it only for the Display purpose then look for Convert Function in Books On Line, SQL Server help fileMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
date format