Import events

Hi,

I'm just planning to do an daily import of an CSV file for events (just to feed up the database).

Does anybody know, in which format the "date" is stored in database?

Date  /  EventStart  /  EventEnd

It's a regular "int" with 11 digits ...

Thanks to all

Hello!

Yes, u're right dates are stored in UNIX_TIMESTAMP format (number of seconds from 1.01.1970). So u need to use query for extracting data like

SELECT ...'fields'..., FROM_UNIXTIME(`EventStart`) as `Start`...

In FROM_UNIXTIME u may set second argument as wishing date format.

Regards

Date                                    EventStart                     EventEnd

1277120386                    1277206758                1277293161

Thanks!

Will setup a script for that, which will daily "fill up" the event's table to bring more content to the community.

Hope I can manage it shortly. Did not think of timestamp Unix ... thanks for the hint ...