Results 1 to 20 of 20
Thread: Capture Fraction of a Second
Jul 17, 2012, 18:28 #1
- Join Date
- Aug 2010
- 0 Post(s)
- 0 Thread(s)
Capture Fraction of a Second
I have a php script which logs every time a person visits someone's Profile. (This could be a Registered Member or an Anonymous Visitor visiting someone's Profile.)
Here is the information I log into MySQL...
$q1 = "INSERT INTO visitor_log(member_viewed, visitor_id, ip, hostname, created_on) VALUES(?, ?, ?, ?, NOW())";
This problem could be fixed by removing the "Unique Index" on the table, but the larger issue is that I need more granularity than NOW() provides.
So, is there a way to capture all of the information that now() currently captures (i.e. Date & Time), but also capture Fractions of Seconds as well?
If so, how would I do this?
I didn't see anything in the manual that captures Date + Time + Micro-Seconds...