Skip to Content.
Sympa Menu

freetds - Re: GetDate is truncated

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • 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
>





Archive powered by MHonArc 2.6.24.

Top of Page