freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: Getting seconds from a datetime field

From: Dan Harris <coronadh AT coronasolutions.com>
To: "TDS Development Group" <freetds AT franklin.metalab.unc.edu>
Subject: Re: Getting seconds from a datetime field
Date: Tue, 2 Jul 2002 10:24:59 -0600

No, it's a datetime type. When I select it, it returns a format of

Jun 1 2002 12:01AM

I would rather have:

2002-06-01 00:01:34

I have tried cast and convert(varchar, colname) but nothing seems to return
seconds.

-Dan

On Monday 01 July 2002 10:19 pm, you wrote:

> 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

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
- Re: Getting seconds from a datetime field, Lowden, James K, 07/03/2002