freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- 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
-
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.