faqts : Computers : Databases : Microsoft SQL Server

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

9 of 28 people (32%) answered Yes
Recently 5 of 10 people (50%) answered Yes

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.