Up Prev Next
From: Michael Peppler <mpeppler at peppler dot org>
Subject: Re: Date formats and Sybase
Date: Jul 9 2001 10:11PM
Arne Claassen writes:
> 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,
> Please, somebody tell me that I'm overlooking some obvious additional date
> types or other way to get dates out of the DB.
That's about it.
But there are various ways to work on this. One fairly obvious way is
to create a view.
There are also ways of setting the default date display format via the
locale setting (although I've not really looked into that).
Mostly I tend to post-process the date format in perl. You can even
play around with things to extract an "epoch" based time
(i.e. something like a what time() returns) and pass that to
Michael Peppler - Data Migrations Inc. - http://www.mbay.net/~mpeppler
email@example.com - firstname.lastname@example.org
International Sybase User Group - http://www.isug.com