Re: getdate print vs select difference

[email protected] Fri, 15 Jul 2011 13:49:32 -0400

Newsgroups	gmane.comp.db.tds.freetds
Message-ID	<[email protected]>

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