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