[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