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 |
|
cplusplus
Aged Yak Warrior
567 Posts |
 Posted - 2010-03-18 : 10:41:48
|
| How to set the date formatting to dd/mm/yyyyI a using this in my Sps:rtrim(isnull(CONVERT(varchar(10),rv.RevisionDate,101),''))Thank you very much for the info. |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2010-03-18 : 10:44:47
|
| Where do you want to show formatted dates?MadhivananFailing to plan is Planning to fail |
 |
|
|
cplusplus
Aged Yak Warrior
567 Posts |
Posted - 2010-03-18 : 10:49:27
|
Hello Madhivanan,This field is used in constructing emailbody. there are almost 40 fields which need to appear in the email bod.+''Revision Date: '' + rtrim(isnull(CONVERT(varchar(10),rv.RevisionDate,101),'''')) + char(13) The dates are appearing with us format, need to show "dd/mm/yyyy"Thank you.quote:
Originally posted by madhivanan
Where do you want to show formatted dates?MadhivananFailing to plan is Planning to fail
|
|
|
|
cplusplus
Aged Yak Warrior
567 Posts |
Posted - 2010-03-18 : 10:52:08
|
| I guess i should use 103 instead of 101. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2010-03-18 : 10:52:51
|
| Useconvert(varchar(10),rv.RevisionDate,103)MadhivananFailing to plan is Planning to fail |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2010-03-18 : 10:53:09
|
 MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Date formatting