How to work with datetime value when the datetime format in dataabase server difference from the datetime format in client machine?

DateTimes are not stored in the database in a formatted way.

So there should be no problem dealing with dateTimes.