Re: php/mysql question? Why are the seconds missing?

[Geoff Cox]

On Fri, 18 Jul 2008 20:13:32 +0100, "Paul Lautman"
<pa**********@btinternet.comwrote:

>This code does NOT obtain data from MySQL in Excel format.

This code obtains data from MySQL in the standard format that MySQL delivers
its data.

The code does NOT even write the data out in Excel format. It writes it out
(very badly code wise) in tab delimited format.

Excel then attempts to guess what type of data is between each delimiter.

If you view the outputted data in a text editor, you will see the seconds
value. Try reformatting the cell in Excel.

Paul,

Thanks for that insight - indeed I can see the seconds using a test
editor!

And yes, if I use a custom format, dd/mm/yyy hh:mm:ss I do get all the
data!

I will follow up the link below too.

Many thanks

Geoff

>
My advice is to output this data in Excel's XML format, then you can specify
precisely what the format should be for each cell.

See: http://msdn.microsoft.com/en-us/libr...ffice.10).aspx

[Geoff Cox]

On Fri, 18 Jul 2008 21:05:39 +0100, Geoff Cox <gc**@freeuk.notcom>
wrote:

using a text editor ...

Geoff