dbTalk Databases Forums  

behavior of SELECT NOW ()

mailing.database.myodbc mailing.database.myodbc


Discuss behavior of SELECT NOW () in the mailing.database.myodbc forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Rubens Jr.
 
Posts: n/a

Default behavior of SELECT NOW () - 07-05-2003 , 12:26 PM






Hi !

In a server with Conectiva Linux 6.0 (A Brazilian version) and Mysql
3.23.36
the comand "SELECT NOW()" returns "2003-07-05 10:00:00" both in
the server and in the clients (Windows 98 with mysql-front and many programs
writen in Delphi and MYODBC 2.50 or Zeos).

In a new server with Conectiva 8 and Mysql 4.0.13
the comand "SELECT NOW()" returns "2003-07-05 10:00:00" only on
the server, but in the clients returns "05/07/2003 10:05:00" !!
This format of date / time is the way we use here in Brazil, BUT the
programs
expect the other way (YYYY-MM-DD HH:MM) and then they crash !

What can I do / configure to get the same response on server and the clients
?

Thanks

Rubens Jr.



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.496 / Virus Database: 295 - Release Date: 03/07/2003


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=m...ie.nctu.edu.tw


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.