Skip to Content.
Sympa Menu

freetds - GetDate is truncated

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Marunde, Emil" <emarunde AT FSC.Follett.com>
  • To: 'TDS Development Group' <freetds AT franklin.oit.unc.edu>
  • Subject: GetDate is truncated
  • Date: Thu, 9 May 2002 14:36:07 -0500


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