freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: [freetds] getdate print vs select difference

From: jklowden AT schemamania.org
To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
Subject: Re: [freetds] getdate print vs select difference
Date: Fri, 15 Jul 2011 13:49:32 -0400

On Fri, Jul 15, 2011 at 11:01:45AM -0400, Ravi Krishna wrote:
>
> Running bsqldb from unix to SS2008 has this oddity
>
> print getdate() produces Jul 15 2011 10:58AM
>
> select getdate() produces Jul 15 2011 10:58:40:360AM

PRINT sends text to the client; server converts the date to a string.

SELECT sends data to the client; bsqldb converts the date to a string.

See also http://www.freetds.org/faq.html#dateformat.

HTH.

--jkl

[freetds] getdate print vs select difference, Ravi Krishna, 07/15/2011
- Re: [freetds] getdate print vs select difference, jklowden, 07/15/2011