.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Forum >> Sql Server >> Post New QuestionBookmark and Share Subscribe to Forum

DateFormat in SQL Server 2000

Posted By: Ruchi     Posted Date: March 12, 2010    Points:2   Category :Sql Server
How can i get
date in dd/mm/yy hh:mm:ss AM/PM format in Sql Server 2000 ?
i want to retrive current date in the above format without substring or any long code . Is there any format for above string ?

Responses
Author: Lalij Mer             
Posted Date: March 12, 2010     Points: 5   

Get Date Time in Any Format - UDF - User Defined Functions
http://blog.sqlauthority.com/2008/08/14/sql-server-get-date-time-in-any-format-udf-user-defined-functions/

More info you will get here for any date formate

http://www.sql-server-helper.com/tips/date-formats.aspx

Please Check my answer if you help....
Thank You...

Lalit.
Author: Syed Shakeer Hussain             
Posted Date: March 13, 2010     Points: 5   

Hi
check the followinglink.more intresting one.

http://www.sqlusa.com/bestpractices2005/centurydateformat/





Post Reply

You must Sign In To post reply
 
 
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more Here
Quick Links For Forum Categories:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  OOPs  SilverlightIISJQuery
JavaScript/VBScriptBiztalkWPFPatten/PracticesWCFOthers
www.DotNetSpark.comUnAnsweredAll

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend