How to get server date via MyODBC

--0-313779436-1104713971=:49922
Content-Type: text/plain; charset=us-ascii

hello!

i wanna know how to get server date via MyODBC.
im using Visual FoxPro 7 + myodbc + mysql 4.0.14nt on XP SP2 machine.
any help is highly appreciated.

thanks




---------------------------------
Do you Yahoo!?
All your favorites on one personal page – Try My Yahoo!
--0-313779436-1104713971=:49922--

Re: How to get server date via MyODBC

> i wanna know how to get server date via MyODBC.
> im using Visual FoxPro 7 + myodbc + mysql 4.0.14nt on XP SP2 machine.
> any help is highly appreciated.
In MySQL you get date by
SELECT CURDATE();

and time by
SELECT CURTIME();

or by
SELECT NOW();

for other date format use
SELECT DATE_FORMAT('date_format',now());

For more details see MySQL manual.

Petr Vileta, Czech republic


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: How to get server date via MyODBC

--0-1842566105-1104717667=:53205
Content-Type: text/plain; charset=us-ascii

thanks a lot Petr

Petr Vileta wrote:> i wanna know how to get server date via MyODBC.
> im using Visual FoxPro 7 + myodbc + mysql 4.0.14nt on XP SP2 machine.
> any help is highly appreciated.
In MySQL you get date by
SELECT CURDATE();

and time by
SELECT CURTIME();

or by
SELECT NOW();

for other date format use
SELECT DATE_FORMAT('date_format',now());

For more details see MySQL manual.

Petr Vileta, Czech republic


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=tatarespecia@yahoo.com




---------------------------------
Do you Yahoo!?
Send a seasonal email greeting and help others. Do good.
--0-1842566105-1104717667=:53205--