[pLog-svn] r3509 - in plog/trunk/class: dao data
Jon Daley
plogworld at jon.limedaley.com
Fri Jun 2 10:54:51 GMT 2006
I forget what it looked like, it was just different from my
server. I went back through the emails, and the only thing I have written
down is that I had to not just "SELECT date", but "SELECT
UNIX_TIMESTAMP(date)", and then later I used "date('blah',
strtotime(date)" to format it correctly for displaying.
The task was to get LT data on a non-LT page.
On Fri, 2 Jun 2006, Oscar Renalias wrote:
> Is that so?
>
> I only noticed two formats for TIMESTAMP(14): YYYYMMDDHHMMSS and
> YYYY-MM-DD HH:MM:SS. Which format did you come across when helping
> this German guy?
>
> On 6/2/06, Jon Daley <plogworld at jon.limedaley.com> wrote:
>> On Fri, 2 Jun 2006, oscar at devel.lifetype.net wrote:
>> > Also, does anybody know why in some databases TIMESTAMP(14) defaults to
>> > one format and sometimes to another?
>>
>> Different locales, right? I was working on a German guy's
>> database, and his timestamps were different, so my original code worked on
>> my blog, but not his.
More information about the pLog-svn
mailing list