SQL Insert with UNIX_TIMESTAMP

[Mega_Man]

Ok, I hope someone can help. Here's my dilemma.
I want to use a INSERT INTO statement into a MySQL table that needs the following information.

A Start date (Unix timestamp)
A Start time (Unix timestamp)
A End time (Unix timestamp)

I have no idea how to convert this into a series of INSERT statements.

I already tried INSERT INTO <table> VALUES (UNIX_TIMESTAMP('04/04/2003')
This works but as no time in included in the date string, I get the wrong value.

The whole purpose of this is to take 3 strings (above) from a VB form and write a INSERT statement that I can then load in PHP which will fill the table entries properly.

Please help. I would like an example based on Date : 04/04/2003, starttime 12:00, Endtime 17:00

Regards,
Mega.

[run_GMoney]

Isn't there a DATESTAMP? If not, the now() function in MySQL inserts a date and a time

[The Hobo]

I'm assuming you're doing this through PHP?

$sql = "INSERT INTO table VALUES ('" . strtotime("04/03/03") . "')";

[Mega_Man]

Originally posted by The Hobo
[B]I'm assuming you're doing this through PHP?

No I'm not. What I am doing is generating a text file which consists of INSERT statements. I am then uploading tht text file to MySQL tables using PHPmYAdmin. I can not use standard PHP commands for this, only transact SQL.

Mega.

[The Hobo]

Originally posted by Mega_Man
No I'm not. What I am doing is generating a text file which consists of INSERT statements. I am then uploading tht text file to MySQL tables using PHPmYAdmin. I can not use standard PHP commands for this, only transact SQL.

Mega.

Ah, forgive me for assuming that this was a PHP question. Not like it's a PHP forum or anything.

I just looked it up, and UNIX_TIMESTAMP(date) should work fine...

[Mega_Man]

I was uncertain as to which forum I should post this in but never mind

Anyway,
Yes the UNIX_TIMESTAMP works fine for a date. The problem I have is how to convert a time into a unix timestamp and store that in a field.

Mega.

[The Hobo]

Just do it the same way:

UNIX_TIMESTAMP('04/04/03 15:26:00')

[Mega_Man]

Ah, the proverbial penny has dropped I think.
I will try this method.

Thanks,
Mega.