Re: Convert excel time to date time

On Sat, 2010-07-17 at 19:47 +0800, Mohd Shakir bin Zakaria wrote: > Hi, > > I've been trying to convert this excel date to the date time format, > but only managed to get it up to the seconds; > > The following code; > > ######### > $data=39604.62164; > date("Y-m-d",mktime(0,0,0,1,$data-1,1900)); > ######### > > will give this output > 2008-06-05 > > changing it to > > ######## > date("H-i-s",mktime(0,0,0,1,$data-1,1900)); > ######## > > will only give > 00-00-00 > > The output I'm looking for is like this one; > 2008-06-05 14:55:09 > > Any idea? > Of course it will, because you're only passing 0 values for the hours, minutes and seconds. I'm not quite sure what the number 39604.62164 represents, or why it is coming up with a value like that when you're passing the number in as the day argument to the date() call, but I assume it allows for a fallover of the date value. Look at the mktime() function on the man page and you'll see the correct usage of it. Thanks, Ash http://www.ashleysheridan.co.uk