but when i will store record in dd-mm-yyyy format and when i will retrive record from database it wi...

Nilesh Makwana

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

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

MuthuMari M14y ago
Accepted answer
Hi,

In db it will store mmm-dd-yyyy. but after retrieving the data from db you have to use like this

Format("dd-MMM-yyyy")

thanks.

If this post is useful then mark it as "Accepted Answer"
0
Lajapathy Arun14y ago
Accepted answer
Hi Nil,

You can use DateTime.TryParseExact , here you can set format and get as Dattime obj and then what format you want you can get here.

http://www.dotnetperls.com/datetime-tryparseexact

Thanks
Lajapathy Arun
0
theLizard14y ago
The rule of thumb for storing dates in ANY database is yyyy-MM-dd or yyyy.MM.dd or yyyy/MM/dd the reason for this is that you do not need to then worry about how dates are handled for different regions.

When done this way you simply say DateTime dt = dbFieldDate and it will be shown for the region you are in determined by the system date time locale.

When assigning a date to a string variable textBox1.Text = dt.ToString("dd-mm-yyyy");

or textBox1.Text = dt.ToString("dd-mm-yyyy" hh:mm:ss);
0
Kunal Vaishya14y ago
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
0