Create Date in the User Database

For general questions and discussions specific to the AbleCommerce GOLD ASP.Net shopping cart software.
Post Reply
User avatar
calvis
Rear Admiral (RADM)
Rear Admiral (RADM)
Posts: 710
Joined: Tue Jan 27, 2004 3:57 pm
Location: Redmond, WA

Create Date in the User Database

Post by calvis » Sun Jun 11, 2017 2:16 pm

Anyone know why the create date is 7 hrs ahead when a new user is created?

The first record says the create date is: June 11, 2017 11:29:22 PM

The date I ran the query is: June 11, 2017 4:56 PM

The date is correct on the server.

Here is the query that we run:

Select Top (100)
ac_Users.CreateDate,
ac_Users.UserName,
ac_Addresses.FirstName,
ac_Addresses.LastName,
ac_Addresses.Address1,
ac_Addresses.City,
ac_Addresses.Province,
ac_Addresses.PostalCode,
ac_Addresses.Phone
From
ac_Users Inner Join
ac_Addresses On ac_Addresses.UserId = ac_Users.UserId
Where
ac_Users.Email Is Not Null
Order By
ac_Users.CreateDate Desc
Able Customer Since 1999 Currently Running on GOLD R12 SR1 and PCI Certified.

User avatar
jmestep
AbleCommerce Angel
Posts: 8164
Joined: Sun Feb 29, 2004 8:04 pm
Location: Dayton, OH
Contact:

Re: Create Date in the User Database

Post by jmestep » Sun Jun 11, 2017 11:41 pm

If I remember correctly, the dates are stored as UTC in the database, so the discrepancy is probably a time zone off set discrepancy.
Judy Estep
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx

User avatar
calvis
Rear Admiral (RADM)
Rear Admiral (RADM)
Posts: 710
Joined: Tue Jan 27, 2004 3:57 pm
Location: Redmond, WA

Re: Create Date in the User Database

Post by calvis » Tue Jun 13, 2017 10:21 am

I believe that to be the case.

Thanks,
Able Customer Since 1999 Currently Running on GOLD R12 SR1 and PCI Certified.

Post Reply