Hai all,

I have  a problem while retrieving the date like the following format.

"  Wed Sep 19 , 2007 "

I have tried like this way..

select CONVERT(varchar,getdate(),107)

But i am getting like this fashion.

"Oct 16, 2007"

I want day has to be come in the first..

Could you able to help me in this regard asap.


Rgrds
Rami reddy. S

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
".NetIndia" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/TechdotNetIndia?hl=en
http://www.satheeshbabu.com
http://www.satheeshbabu.blogspot.com/
-~----------~----~----~----~------~----~------~--~---

Reply via email to