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 |
msantosa
Starting Member
16 Posts |
Posted - 2006-08-21 : 15:27:09
|
Hello, I want to getdate() with this format Mon, 21 Aug 2006 07:27:36Get it be done?Thank you :) |
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-08-21 : 15:36:32
|
Closest rselect convert(varchar(50),getdate(),100)select convert(varchar(50),getdate(),109)And u better do this in ur front endSrinika |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-08-21 : 21:07:13
|
[code]select left(datename(weekday, getdate()), 3) + ', ' + convert(varchar(20),getdate(),113)[/code] KH |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-08-26 : 04:21:46
|
Where do you want to show data?If you use front end application, do formation thereMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
|