freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: date type in ms sql 7.0

From: James Cameron <cameron AT stl.dec.com>
To: TDS Development Group <freetds AT franklin.oit.unc.edu>
Subject: Re: date type in ms sql 7.0
Date: Wed, 04 Oct 2000 08:25:24 +1100

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?

--
James Cameron (cameron AT stl.dec.com)

date type in ms sql 7.0, Sam Sam, 10/03/2000
- <Possible follow-up(s)>
- RE: date type in ms sql 7.0, Wasson, Tim, 10/03/2000
- Re: date type in ms sql 7.0, James Cameron, 10/03/2000
- Re: date type in ms sql 7.0, Bob Kline, 10/03/2000
- FW: Re: date type in ms sql 7.0, Lowden, James K, 10/04/2000
- Re: FW: Re: date type in ms sql 7.0, James Cameron, 10/04/2000