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
