X-Cart forums

[pipercub]

I'm preparing to write a script that will export customer shipping data for the FedEx system. I want to be able to export this data based on the customers first login (to avoid importing multiple addresses into FedEx). When I look at the 'xcart_customers' table, I do see the 'first_login' field, but the format is something that I don't recognize.

Example:

A customer who registered today 10/28/2003 has '1067361098' in the 'first_login' field.

I'd be willing to guess that the first two numbers in that string is the month. Beyond that I'm lost. I checked some Smarty References as well as some MySQL references, but I had no luck.

Thanks,
Piper

[shan]

its a mysql timestamp (number of seconds since jan 1 1970) check mysql.com for more info on timestamps

[pipercub]

Number of seconds since Jan 1970... how do I always overlook the obvious!

Piper