| ||||||||||
Shopping cart software Solutions for online shops and malls | ||||||||||
|
X-Cart Home | FAQ | Forum rules | Calendar | User manuals | Login |
"First Login" strange date format in DB? | |||
|
|
Thread Tools | Search this Thread |
#1
|
|||||||
|
|||||||
"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 |
|||||||
#2
|
|||||||||
|
|||||||||
its a mysql timestamp (number of seconds since jan 1 1970) check mysql.com for more info on timestamps
__________________
Looking for a reliable X-cart host ? You wont go wrong with either of these. EWD Hosting Hands On Hosting |
|||||||||
#3
|
|||||||
|
|||||||
Number of seconds since Jan 1970... how do I always overlook the obvious!
Piper |
|||||||
|
|||
X-Cart forums © 2001-2020
|