freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: Getting seconds from a datetime field

From: James K. Lowden <jklowden AT speakeasy.org>
To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
Subject: Re: Getting seconds from a datetime field
Date: Tue, 2 Jul 2002 00:19:30 -0400

On Mon, 1 Jul 2002 16:01:01 -0600, "Dan Harris"
<coronadh AT coronasolutions.com> wrote:

> I'm stuck trying to get seconds in a resultset containing a date/time
> field. Every time it's returned I only get down to the minutes. Somone
> posted a way to do this some months ago but I can't find it.

Dan,

Are you using smalldatetime? It lacks seconds and milliseconds.

If you're thinking of cast/convert, see
http://www.SchemaMania.org/jkl/booksonline/SQLBOL70/html/ca-co_1.htm

HTH.

--jkl

Getting seconds from a datetime field, Dan Harris, 07/01/2002
- <Possible follow-up(s)>
- Re: Getting seconds from a datetime field, James K . Lowden, 07/01/2002
- Re: Getting seconds from a datetime field, Dan Harris, 07/02/2002
- Re: Getting seconds from a datetime field, Eric Deutsch, 07/02/2002
- Re: Getting seconds from a datetime field, Lowden, James K, 07/02/2002
- Re: Getting seconds from a datetime field, Dan Harris, 07/02/2002
- Re: Getting seconds from a datetime field, Dan Harris, 07/02/2002
- Re: Getting seconds from a datetime field, Dan Harris, 07/02/2002
- Re: Getting seconds from a datetime field, Brian Bruns, 07/02/2002
- Re: Getting seconds from a datetime field, Michael Peppler, 07/02/2002
- Re: Getting seconds from a datetime field, James K. Lowden, 07/03/2002
- Re: Getting seconds from a datetime field, Brian Bruns, 07/03/2002