Skip to Content.
Sympa Menu

freetds - Re: 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: Re: GetDate is truncated
  • Date: Thu, 9 May 2002 15:27:31 -0500


I have no problem getting a text blob out of MSSQL.

Can you have more than one connection using Sybase and MSSQL?

Emil

-----Original Message-----
From: Michael Hudin [mailto:hudin AT zoetrope.com]
Sent: Thursday, May 09, 2002 3:14 PM
To: TDS Development Group
Subject: [freetds] Re: GetDate is truncated


I don't have a solution to your problem unfortunately, but you have a very
similar configuration to mine, but I assume that you are able to pull blobs
out of your database without any problem? I keep having the file get
truncated when it it removed. The only difference between my setup and
yours is that I am using DBD:Sybase. Do you have any info on this problem?

----- Original Message -----
From: "Marunde, Emil" <emarunde AT FSC.Follett.com>
To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
Sent: Thursday, May 09, 2002 12:36 PM
Subject: [freetds] GetDate is truncated


> 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
>
> ---
> You are currently subscribed to freetds as: [hudin AT zoetrope.com]
> To unsubscribe, forward this message to
$subst('Email.Unsub')
>
>


---
You are currently subscribed to freetds as: [emarunde AT fsc.follett.com]
To unsubscribe, forward this message to
$subst('Email.Unsub')




Archive powered by MHonArc 2.6.24.

Top of Page