Michael Peppler
Sybase Consulting
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
Sybase on Linux FAQ
Sybperl FAQ
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: dowen at midsomer dot org
Subject: Re: Date formats and Sybase
Date: Jul 9 2001 10:14PM

> Ok, this may be a newbie, rtfm sort of question, but every time i look up
> the answer in the Sybase docs, i fail to believe it. Am i missing something
> or is Sybase's date display format conversion about the most limited of any
> DB? More to the point, unless i'm missing something there does not seem to
> be a way to get the dates out in any format that will give date and time in
> a 24 hour numerical only format, unless i do something like:
>     convert(char(10), date_field, 111) + " " + convert(char(8), date_field,
> 108)
> Please, somebody tell me that I'm overlooking some obvious additional date
> types or other way to get dates out of the DB.
A quick look at Rob Verschoor's handy guide tells me that you are correct.  A bit
sad really.