Tim
Access has only one date/time data type. With SSMA (SQL Server Migration Assistant), you should be able to select the datetime data type for each date field. SQL Server, being a more robust engine always includes the time as well as the date. datetime2 has more accuracy and a longer range than datetime (the most common date data type). The data type date does not have the time but I strongly advise against using it.
If you want to show just the date you can always format it in forms and reports like this:
Format([myDateField], "mm/dd/yyyy")
Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
http://mvp.microsoft.com/en-us/mvp/Bill%20Mosca-35852
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com
__._,_.___
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (3) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar