Core Data Date Storage SQLite TimeStamp Microsoft SQL Server
===

This is a rather Long Winded Question, I am New to this, my apologies.

I have a Cocoa Core Data Application that uses a NSManaged Object Model and reads and writes to a SQLite Object Store.

The NSManged Object contains an NSDate Attribute.

@property (nonatomic, retain) NSDate * dateOfContact;

Everything works fine UNTIL I export the Data from SQLite to an SQL File and Try to Execute that file on a Microsoft SQL Server.

The SQLite Export File says that the Date Field is a TimeStamp. But when I try to Import to MicroSoft SQL Server it says it cannot insert an explicit value into a TimeStamp Field.

After doing some research, I Found that a TimeStamp Field in Microsoft SQL Server has Special Meaning for the Row and cannot be used.

I am tiring to make this as seamless as possible, I have searched and searched the Internet but I can't find a solution to this.

The Only Thing I can think of is to change the Core Data Model so that My Date is actually a String Value and Store it as a String. That way I would avoid the SQLite/TimeStamp/Microsoft SQL server issue altogether.

Is there a way to Keep My Model Attribute as a Date but Store it as a String or something else that can import easily into Microsoft SQL Server ?

Why is a TimeStamp not a TimeStamp in SQL...Who is Wrong Here Cocoa, SQLite or Microsoft ?