Storing date in dd/mm/yyy format

mike_remember · May 8th, 2008, 02:24 AM

Hi

I am storing date in the dd/mm/yyyy format into the SQL Server database, but while I do a search on dates, I am not getting proper results, I mean when the date is say 05/05/2008, these rows are ommitted. Can anyone help on how to store and fetch dates in the dd/mm/yyy format...

Regards
Mike

weicco · May 13th, 2008, 04:23 AM

Don't format datetime values when you are storing them. Just store them in DateTime datatype and be happy about it. Things get a lot easier. You don't need to do any tedious casting/formatting when comparing values. You can simply say "SELECT * FROM MyTable WHERE MyTimeStamp > @startDate AND MyTimeStamp < @endDate" for example.

When displaying the data to user do your formatting stuff there. Something like DateTime.ToString("dd/MM/yyy") or whatever.