Loading

Store neutral date in database

Casper Hansen

Hello all

I am building a website and I want to store the current time in a database, thats not a problem.

But I also want to make the time format changable. For example if I have "May 2 2009" stored in the database and I decide I want to change the format to "5/2/2009", I need to either update the database or use a neutral date format that can be converted to the date format I want.

Any tips on this? I thought about using timestamp, but cant rellay see where it fits in

Thanks

1 Reply

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

Rodick Wu17y ago
DateTime dt = DateTime.Now; string formatDate = dt.ToString("MM/dd/yyyy"); MessageBox.Show(formatDate);