Unix timestamp

[knowledg3]

I pulled a unix timestamp from microsoft access into a php program and converted it using date. But How would I get the current date and convert it to MM/DD/YYYY Format into a unix timestamp?

thanks in advance

[scoppc]

I dont really get what's your problem, actually but to get the current time in unix timestamp u can use the time() function.
You can then use date function to convert it to any format u wish.

print date("d F Y",time());

The above code will give you 15 April 2003.

Yo convert the MM/DD/YYYY format to Unix timestamp, use mktime() function.

[knowledg3]

well I'm trying to stick the current date back into a colum in a table in my database. the type is date/time

$DateEvent = mktime(0,0,0,date("m"),date("d"),date("Y"),-1);

$sql = "INSERT INTO Event(EventNo,EventUserID,EventType,EventPriority,EventDueDate,EventDesc,EventDate) VALUES ($HighestNo,'$user','$EventT','$EventP','$EventDue','$EventText',$DateEvent)";

this is the echo from my sql statement

INSERT INTO Event(EventNo,EventUserID,EventType,EventPriority,EventDueDate,EventDesc,EventDate) VALUES (5,'rbcboca','Hardware Issue','Normal','4/18/2003','Test ticket',1050379200)

this is the error

Warning: (null)(): Invoke() failed: Exception occurred. Source: Microsoft OLE DB Provider for ODBC Drivers Description: [Microsoft][ODBC Microsoft Access Driver]Numeric value out of range (null) in

C:\Inetpub\wwwroot\Mouse Tracks\Interface\index.php on line 239

[knowledg3]

nevermind I figured it out. Thanks for your help though

btw.... I'm with stupid:eek: