View Single Post
  #1  
Old 10-28-2003, 10:33 AM
 
pipercub pipercub is offline
 

Advanced Member
  
Join Date: Oct 2002
Posts: 82
 

Default "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
Reply With Quote