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
u get does not
necessarily represent a valid date/time!
Just replace 06 with 24 and see what you yet.
Cheers
/rudy
-Original Message-
From: Johannes Pretorius [mailto:[EMAIL PROTECTED]
Sent: woensdag 16 juli 2003 12:11
To: [EMAIL PROTECTED]
Subject: Re: Simple newbie question - CURTIME(
: Johannes Pretorius [mailto:[EMAIL PROTECTED]
Sent: woensdag 16 juli 2003 12:11
To: [EMAIL PROTECTED]
Subject: Re: Simple newbie question - CURTIME()
Thanks I have figured it out, I only have to add 06 to the curtime()
function as example :
//== SNIP
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 | TheCurrenTime |
+---
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 server, thus the time of the syst
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
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
