when i will store date in dd-mm-yyyy format but it will bydefault store in MM-dd-yyyy format so how to change the format

Question

1> when i will store date in dd-mm-yyyy format but it will bydefault store in MM-dd-yyyy format so how to change the format 2> and when i will fetch date from database how to convert date format

Kunal Vaishya · Answer

If you dont wat do this so you can also do this at coding side DateTime Dt = DateTIme.Now() // Or DataBase Value Dt.ToString("dd-MM-yyyy")

Kunal Vaishya · Answer

Dear Like Employee Table Id Numeric Name Varchar(20) DOB DateTime Like This Select Id, Name, select convert(varchar, DOB, 105) As DateOfBirth From Employee

Nilesh Makwana · Answer

in simple how to fetch & convert date record from database in dd-MM-YYYY format

Kunal Vaishya · Answer

Dear Sql Inbuild Date Time Formate is MM-dd-yyyy if you store date in dd-MM-yyyy format then check data is proper or not may be . Sql Formate IS MM-dd-yyyy When you store 12-12-2012 It will not give you error but is wrong thats mean if you ar passing date like this date-Month-year it wring in case of 13-12-2012 it will give you error so try to do this type of testing to beter undastanding give me code i'll help you

Nilesh Makwana · Answer

but when i will store record in dd-mm-yyyy format and when i will retrive record from database it will also display record in mm-dd-yyyy but i want to record in dd-mm-yyyy and another thing is getdate() will display current dat in dd-mm-yyyy format

NIlesh Patel · Answer

Dear Nilesh It Is No need to Change Format In SqlServer. When You Retrive Data From Database Use 'select convert( varchar(50),getdate(),103)' This type of Syntax To get date in 'dd-mm-yyyy' Format .and It is Better way to store date in sql in MM-dd-yyyy format at saved record.

Kunal Vaishya · Answer

Dear In Sql we cant change data in DateTIme Field its own formate When you fech data you can use like this Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable{mso-style-name:"Table Normal";mso-tstyle-rowband-size:0;mso-tstyle-colband-size:0;mso-style-noshow:yes;mso-style-priority:99;mso-style-qformat:yes;mso-style-parent:"";mso-padding-alt:0in 5.4pt 0in 5.4pt;mso-para-margin:0in;mso-para-margin-bottom:.0001pt;mso-pagination:widow-orphan;font-size:11.0pt;font-family:"Calibri","sans-serif";mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;mso-fareast-font-family:"Times New Roman";mso-fareast-theme-font:minor-fareast;mso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;mso-bidi-font-family:"Times New Roman";mso-bidi-theme-font:minor-bidi;} USA mm/dd/yy select convert(varchar, getdate(), 1) ANSI yy.mm.dd select convert(varchar, getdate(), 2) British/French dd/mm/yy select convert(varchar, getdate(), 3) German dd.mm.yy select convert(varchar, getdate(), 4) Italian dd-mm-yy select convert(varchar, getdate(), 5) dd mon yy select convert(varchar, getdate(), 6) Mon dd, yy select convert(varchar, getdate(), 7) USA mm-dd-yy select convert(varchar, getdate(), 10) JAPAN yy/mm/dd select convert(varchar, getdate(), 11) ISO yymmdd select convert(varchar, getdate(), 12) mon dd yyyy hh:miAM (or PM) select convert(varchar, getdate(), 100) mm/dd/yyyy select convert(varchar, getdate(), 101) yyyy.mm.dd select convert(varchar, getdate(), 102) dd/mm/yyyy select convert(varchar, getdate(), 103) dd.mm.yyyy select convert(varchar, getdate(), 104) dd-mm-yyyy select convert(varchar, getdate(), 105) dd mon yyyy select convert(varchar, getdate(), 106) Mon dd, yyyy select convert(varchar, getdate(), 107) hh:mm:ss select convert(varchar, getdate(), 108) Default + milliseconds mon dd yyyy hh:mi:ss:mmmAM (or PM) select convert(varchar, getdate(), 109) mm-dd-yyyy select convert(varchar, getdate(), 110) yyyy/mm/dd select convert(varchar, getdate(), 111) yyyymmdd select convert(varchar, getdate(), 112) Europe default + milliseconds dd mon yyyy hh:mm:ss:mmm(24h) select convert(varchar, getdate(), 113) or select convert(varchar, getdate(), 13) hh:mi:ss:mmm(24h) select convert(varchar, getdate(), 114)

when i will store date in dd-mm-yyyy format but it will bydefault store in MM-dd-yyyy format so how to change the format

Answers (7)