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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 get day, date and time

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:36

Get it be done?
Thank you :)

Srinika
Master Smack Fu Yak Hacker

1378 Posts

Posted - 2006-08-21 : 15:36:32
Closest r

select convert(varchar(50),getdate(),100)
select convert(varchar(50),getdate(),109)

And u better do this in ur front end

Srinika
Go to Top of Page

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

Go to Top of Page

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 there

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -