SQL Compact: What is the best data type to store time data


  • Hi Guys,

    I am trying to store a start and end time in SQL compact version 3.5 or newer and need to be able to work out the time btween the start and end time. This data will be used by entity frame work with WPF and Reports (rdlc). In SQL sever there is a Time data type. What would be the best data type to store this time considering what I am trying to use it with?

    I notice that the SQL Conpact tool box option to generate a sql compact 4 DB from SQL server converts Time fields to nchar.

    Thanks Jake

    Monday, September 16, 2013 1:40 PM


All replies