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.