FreeTDS Development Group

[Bob Kline <bkline AT rksystems.com>]

On Wed, 4 Oct 2000, James Cameron wrote:

> Bob Kline wrote:
> > 1. Chop off the part you don't want; or
> > 2. Use the CONVERT function with the style you want.
> 
> Given that I want the seconds and can't seem to get them, how would I
> use CONVERT to get them?

This is a different question than the original poster asked, as he
wanted the date part but not the time.  The unfortunate fact is that
Microsoft has seen fit to omit the standard's DATE and TIME data types
from its implementation of SQL.  In your case, you can use style value 8
(or 108) to get back a string in the form hh:mm:ss.  If you *only* want
the seconds (for whatever reason), you should look at using the DATEPART
function.

-- 
Bob Kline
mailto:bkline AT rksystems.com
http://www.rksystems.com