freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: datetime format

From: James Cameron <cameron AT fax.sno.cpqcorp.net>
To: TDS Development Group <freetds AT franklin.oit.unc.edu>
Subject: Re: datetime format
Date: Tue, 18 Dec 2001 09:41:34 +1100

"Winkless, Geoff" wrote:
> You may find that you need to put
> SET DATEFORMAT YMD

According to documentation, this only affects date input to the SQL
server, not SELECT output.

http://msdn.microsoft.com/library/en-us/tsqlref/ts_set-set_052s.asp

--
James Cameron (james.cameron AT compaq.com)

"Think of it as evolution in action." -- Larry Niven

datetime format, Bradley Bell, 12/13/2001
- <Possible follow-up(s)>
- Re: datetime format, James Cameron, 12/13/2001
- Re: datetime format, James K. Lowden, 12/16/2001
- Re: datetime format, Winkless, Geoff, 12/17/2001
- Re: datetime format, Lowden, James K, 12/17/2001
- Re: datetime format, Bradley Bell, 12/17/2001
- Re: datetime format, James Cameron, 12/17/2001
- Re: datetime format, Michael Peppler, 12/17/2001
- Re: datetime format, James K. Lowden, 12/18/2001
- Re: datetime format, Steve Langasek, 12/19/2001
- Re: datetime format, Brian Bruns, 12/19/2001
- Re: datetime format, Franck Martin, 12/19/2001
- Re: datetime format, Steve Langasek, 12/19/2001
- Re: datetime format, Bradley Bell, 12/19/2001
- Re: datetime format, Bradley Bell, 12/19/2001
- Re: datetime format, Michael Peppler, 12/20/2001
- Re: datetime format, Geoff Winkless, 12/24/2001