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 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 6 hours to the time on capturing of the data, but using curtime() and adding the difference gives the wrong time back, must we add the amount seconds or minutes to the function to get the correct time ? Thanks in Advance for all help Johannes Pretorius -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
