Skip to Content.
Sympa Menu

freetds - Re: [freetds] getdate print vs select difference

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • 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






Archive powered by MHonArc 2.6.24.

Top of Page