PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: umesh at DBNA dot COM
Subject: Help with SQL Server 7 and datetime
Date: Sep 18 2000 3:05PM

I am in the process of upgrading from SQL server 6.5 to 7 and run into
a problem with datetime columns after upgrading my database. If I
"select" a column containing today's date, I get the date as "Jan 1
1900". The result is correct if I use the convert function.

This tells me that while the server has the right date, the
isql/sybperl programs are interpreting data incorrectly. Is there any
way to avoid the problem without changing the code on the client side?

Many thanks.