"First Login" strange date format in DB?
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
|