Time question

8mycsh

I have a excel sheet that has all my info I want to put into a mysql db.

I have a time field in the sheet.
I want to import the sheet into an existing db. In the db there is a time colum but it is in this format 108121200. I wasn't the one who created the php script but I believe he his using the mktime function or something similar. I was curious is there a formula that I can use to change time from 05:00pm to something like above (108121200).

I have 2500 entires to put into the db so I am not looking forward to maunally entering these using a php entry script but possibly a formula I can run in excel to convert and then do an insert into mysql.

Thanks for your help.

mmilano

the unix timestamp is a combination of a date and time.

do you have a date for that time field?

if so, you maybe able to use strtotime() to accomplish this.

sorry i don't have an example for you, but maybe that will point you in the right direction.

dalecosp

Originally posted by mmilano
the unix timestamp is a combination of a date and time.

do you have a date for that time field?

if so, you maybe able to use strtotime() to accomplish this.

sorry i don't have an example for you, but maybe that will point you in the right direction.

Now, now.

strtotime might help, but your assertion that "the unix timestamp is a combination of a date and time" is not true.

A unix timestamp represents the number of seconds that have passed since the "epoch", which was midnight on January 1, 1970...this is why calling time functions with a bad value will get you a "11:59 PM December 31, 1969" from date() every time...