Re: datetimeoffset & ms sql 2008

Thomas Stover wrote:
> I found this message:
>
> http://lists.ibiblio.org/pipermail/freetds/2008q1/023035.html
>
> Just wondering if any progress had been made on getting the offset and 
> / or fractional second info out of these data types. If anyone knows 
> some sql syntax that might let you pull that info perhapses as int and 
> float columns that would work also.
>
Well, I should have googled harder:
http://technet.microsoft.com/en-us/library/ms174420.aspx

You can use the datepart() facility to ask for a specific component of 
the datetimeoffset.