Entry

Is it possible to have to formats for the datetime data type in the same db? I am looking at a db with one table ddmmyyyy and another table mmddyyy!

Apr 3rd, 2001 06:12
Morgan Curley, Simon Coffey,

check that both columns are of type date and your select statements are 
doing the same conversion if any.