Re: sybase-ct and datetime results

On Wed, Apr 25, 2001 at 10:59:15PM +0200, Björn Dolkemeier wrote: > (I posted this also to php.db, but the more I think php.dev would be a > better place) > > Hello, > > If I do a sybase_query("select getdate()",$Conn) this will return the > current date in the format "Nov 3 1998 8:06PM" (so I don't have seconds). > I think this leads to the usage of CS_SHORT_DATE in > ext/sybase_ct/php_sybase_ct.c (Line 275). > > Does somebody know, if there is a solution for getting another > datetime-format beyond doing something like sybase_query("select > convert(varchar,getdate(),108)". The only way for the moment is using convert(). Sybase is not playing very nice with datetimes. I noticed this behaviour before in other programs and came to see that it is the server which doesn't return right. > Wouldn't it be better to return the "datetime-results" of queries as a > timestamp? Or have a php.ini-setting / global parameter how to return > "datetime-results"? so this is not an option :( -- Jo Giraerts Development Services Engineer VA Linux Professional Services Europe Interleuvenlaan 15A, 3001 LEUVEN, BELGIUM icq:81939849, email:jo@life.be, ph0ne:+32(0)475/437719 I've got these opium queens that move around my space, I said it's waste not, want not, I think I'll take another, I'm holding all this pain that I'm trying to smother. <branvan3000 - Afrodisiac>