GetDate is truncated
Brian Bruns
camber at ais.org
Thu May 9 21:35:37 EDT 2002
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
>
More information about the FreeTDS
mailing list