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 |
|
seeker61
Starting Member
4 Posts |
 Posted - 2013-05-16 : 09:36:05
|
| I want the above format but CONVERT(DATE,MAX(CAST(VALUE AS date)),101) gives me yyyy/mm/dd what do i need to do |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2013-05-16 : 09:40:44
|
CONVERT(varchar(10),MAX(CAST(VALUE AS date)),101)
Too old to Rock'n'Roll too young to die. |
 |
|
|
seeker61
Starting Member
4 Posts |
Posted - 2013-05-16 : 09:46:31
|
| Thanks. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2013-05-17 : 04:30:19
|
| However if you want to show them in a front end application, you can return DATETIME values as such and use format function thereMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
mm/dd/yyyy