in sql server if we give data type as datetime then in open table option how we write it

Dear Friend,

You can write the datetime in this format for open table in sql server


[YYYY][MM][DD][HH]{MM][SS][FFF]

where YYYY=Year
MM=Month
DD=Date
HH=Hour
MM=Minutes
SS=Seconds
FFF=Fractional part of seconds


For more details please visit this link:-

http://msdn.microsoft.com/en-us/library/ms187819.aspx[^]

If it helps you out then don't forget to mark this as your answer.

Thanks