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: "David LANDGREN" <dlandgre at bpinet dot com>
Subject: Re: Differences in convert()ed AM/PM times
Date: Jan 23 2002 9:56AM

|I think the fundamental problem with:
|
|    select convert(char(20),max(my_date, 109) from t
|
|is that the string is too short and so the time part of the string is
|truncated.

Omigod, how embarrassing. I wince at the thought of the amount of time I
wasted on this yesterday.

/me looks for a convenient hole to crawl into.

Thanks,
David