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:Calibrisans-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)