• •Datetimeoffset whenever the data will refer to an exact point in time - transaction/added/updated datetimes (UTC) and localized datetimes.

    •Datetime for any cases where the time is irrelevant across time zones or the timezone is simply not known - imported data, standard datetimes that are the same across timezones, etc.

    •Datetime with a 00:00:00 time to represent whole dates - dates of birth

    •Time for just times of the day where the date is irrelevant - opening hours, etc.

    Since you're using Time for the time of day where date is irrelevant,

    Why are you not using the Date data type for Dates where time is irrelevant (such as dates of birth)?



    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]