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
Create Date in the User Database
Create Date in the User Database
Able Customer Since 1999 Currently Running on GOLD R12 SR1 and PCI Certified.
- jmestep
- AbleCommerce Angel
- Posts: 8164
- Joined: Sun Feb 29, 2004 8:04 pm
- Location: Dayton, OH
- Contact:
Re: Create Date in the User Database
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
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
Re: Create Date in the User Database
I believe that to be the case.
Thanks,
Thanks,
Able Customer Since 1999 Currently Running on GOLD R12 SR1 and PCI Certified.