Skip to Content.
Sympa Menu

freetds - Re: [freetds] datetimeoffset & ms sql 2008

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Thomas Stover <thomas AT wsinnovations.com>
  • To: freetds AT lists.ibiblio.org
  • Subject: Re: [freetds] datetimeoffset & ms sql 2008
  • Date: Thu, 12 Nov 2009 14:51:23 -0600

Thomas Stover wrote:
I found this message:

https://lists.ibiblio.org/sympa/arc/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.




Archive powered by MHonArc 2.6.24.

Top of Page