Re: curtime

t; An: "Mysql (E-mail)" <[EMAIL PROTECTED]> Gesendet: Mittwoch, 20. August 2003 15:54 Betreff: curtime When I write select curtime(); It´s return the mysql´s system time, but I would like to change this time (because it´s late 3 minutes) Any ideas? Thanks a lot -- MyS

Re: curtime

On Wed, Aug 20, 2003 at 10:54:28AM -0300, Fabio Bernardo wrote: > When I write > select curtime(); > It?s return the mysql?s system time, but I would like to change this time > (because it?s late 3 minutes) Then your system's time need to be updated correctly. > Any ideas?

curtime

When I write select curtime(); It´s return the mysql´s system time, but I would like to change this time (because it´s late 3 minutes) Any ideas? Thanks a lot

RE: Simple newbie question - CURTIME()

SELECT EXTRACT(HOUR_SECOND FROM "1999-07-02 01:02:03"); -Original Message- From: Johannes Pretorius [mailto:[EMAIL PROTECTED] Sent: woensdag 16 juli 2003 13:32 To: [EMAIL PROTECTED] Cc: Pieter Subject: RE: Simple newbie question - CURTIME() Thanks \0-\-==-0-= I have seen my

RE: Simple newbie question - CURTIME()

---+ 1 row in set (0.03 sec) //== END SNIP == Thanks Johannes At 13:06 16/07/2003 +0200, you wrote: WRONG! What will happen in this case? The DB is converting/casting the DATE (curtime()) into an integer and then ads 6. So what yo

RE: Simple newbie question - CURTIME()

WRONG! What will happen in this case? The DB is converting/casting the DATE (curtime()) into an integer and then ads 6. So what you get does not necessarily represent a valid date/time! Just replace 06 with 24 and see what you yet. Cheers /rudy -Original Message- From

Re: Simple newbie question - CURTIME()

Thanks I have figured it out, I only have to add 06 to the curtime() function as example : //== SNIP mysql> select curtime() + 06 as TimePlus6, curtime() as TheCurrenTime; +---+---+ | TimePlus6 | TheCurrenT

Re: Simple newbie question - CURTIME()

Johannes Pretorius <[EMAIL PROTECTED]> wrote: > I have looked in the manual and seem to be missing it or not understanding > correctly, > > The curtime() function resturns the current server time. my problem is the > clients are not in the same > country as the serv

RE: Simple newbie question - CURTIME()

Please check the manual, search for DATE_ADD(). /rudy -Original Message- From: Johannes Pretorius [mailto:[EMAIL PROTECTED] Sent: woensdag 16 juli 2003 8:01 To: [EMAIL PROTECTED] Cc: Pieter Subject: Simple newbie question - CURTIME() Good day \-=0=-=00- I have looked in the manual and

Simple newbie question - CURTIME()

Good day \-=0=-=00- I have looked in the manual and seem to be missing it or not understanding correctly, The curtime() function resturns the current server time. my problem is the clients are not in the same country as the server, thus the time of the system is 6 hours behind. We want to add

Re: "select CURTIME - " returns NULL sometimes

At 19:53 -0300 10/15/02, Joao A. Marques wrote: >Hi, >I´m getting problem with function CURTIME(). >The problem happens, apparently, when then current seconds of the current >time (server´s time) is between 43 and 59, as result of "CURTIME - type TIME>". >See : No, th

"select CURTIME - " returns NULL sometimes

Hi, I´m getting problem with function CURTIME(). The problem happens, apparently, when then current seconds of the current time (server´s time) is between 43 and 59, as result of "CURTIME - ". See : [root@test01 /root]# mysql Welcome to the MySQL monitor. Commands end with ; or \g.