freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- From: Brian Bruns <camber AT ais.org>
- To: TDS Development Group <freetds AT franklin.metalab.unc.edu>
- Subject: Re: GetDate is truncated
- Date: Thu, 9 May 2002 20:35:37 -0400 (EDT)
if you are running a recent cvs snapshot then edit the etc/locale.conf
file and adjust the string to a valid strftime(3) time string.
Brian
On Thu, 9 May 2002, Marunde, Emil wrote:
> I'm currently using Perl on RedHat 7.2, MSSQL 2000, unixODBC, freeTDS,
> DBD::ODBC.
>
> I'm trying to get a starting timestamp from MSSQL to use latter for logging.
>
> This is a copy of the Perl code.
>
> {
> my $sthGetDate = $dbh->prepare("SELECT GETDATE()");
> $sthGetDate->execute();
> $SQL_StartTime = $sthGetDate->fetchrow_array;
> $sthGetDate->finish();
> }
>
> $SQL_StartTime is always truncated to the nearest minute.
>
>
> Emil
>
-
GetDate is truncated,
Marunde, Emil, 05/09/2002
- <Possible follow-up(s)>
- Re: GetDate is truncated, Michael Hudin, 05/09/2002
- Re: GetDate is truncated, Marunde, Emil, 05/09/2002
- Re: GetDate is truncated, Michael Hudin, 05/09/2002
- Re: GetDate is truncated, Brian Bruns, 05/09/2002
- Re: GetDate is truncated, Marunde, Emil, 05/10/2002
- Re: GetDate is truncated, James Cameron, 05/12/2002
Archive powered by MHonArc 2.6.24.