Hi!

i've mysql-3.23.39-nt on winnt with a client running under SCO 3.2

i've a simple querry with date_format in it, but date_format isn't doing 
what i expect...


sql_string:   "select date_format(c.hour, '%Y%m%d%H'), c.hour from count c"
c.hour is DATETIME

okay, i see this output on my sco-machine:
'2001071614' '2001-07-19 14:00:00'

if i try the same with mysql-front on my win2k machine:
'2001071914' '2001-07-19 14:00:00'

?!?
i'm using the C-API (libmysqlclient.a) from 
mysql-3.23.38-pc-sco3.2v5.0.6-i386.tar.gz

any ideas ? what should i do? a new libmysqlclient ?
thx!

-- 

Florian Schmidt
mailto:[EMAIL PROTECTED]
http://www.f-24.com


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to