[MS_AccessPros] Re: Date Format Issue in Access 2013 FrontEnd and SQL Server 2012 BackEnd

 

hi Tim

I don't know how many times the business rule started out "Oh, we only need the date, not the time." only to have it change down the road. With datetime, you can always format the outcome to show only the date.

I don't recommend datetime2 unless you need that kind of accuracy (chasing atoms). Besides, if Access is your front end it can't see milliseconds.

-Bill

---In MS_Access_Professionals@yahoogroups.com, <timdbui@gmail.com> wrote :

Hi Bill,

Would you please elaborate why you do not recommend the "date" function in SQL server and I should go for "datetime2(0)"?

Thanks!

Tim

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (8)

Visit Your Group

• New Members 6

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___