The query is simple

UPDATE w3t_Users
SET U_Registered = 'xxxxx'
WHERE U_Username = 'yyyyy'

Now the trick is that the xxxxx (date) above needs to be in a numerical epoch format.

epoch format is basically the number of seconds since Jan 1, 1970 GMT.

Because I've had to do some fooling with threads dates and times... I wrote a little script which will convert a real date and time to epoch format...... and convert an epoch format to a human readable format.

You can use it at http://www.joshuapettit.com/time.php

Hope that helps. <img border="0" title="" alt="[Wink]" src="images/icons/wink.gif" />

Josh
Measurection.com Admin | ThreadsDev.com Moderator
Register to see my How To/Site Help Library Forum at ThreadsDev.com.
My threads 'tweaking' abilities are for hire.