1 Topic by Endre

  • Endre
  • Senior Member
  • Offline
  • From: Norway
  • Registered: 2005-02-20
  • Posts: 165

Topic: inserting date/time in database

Not a pun-related question, but you guys seem knowledgable, so I'll ask anyway smile

When I converted my user database to punbb, the registration info was nullified for all users, leaving them all as "registered 1969".
Now I want to manually adjust this info for all the users, but I can't figure out the date-system in my database (mysql).

A new member registered yesterday, on March 13, 2005. The data in the database field "registered" looks like this: 1110741859
If I copy that to another user, the also appear as registered that date.

So I guess there is some kind of logic to why 1110741859 means March 13, 2005, right?
Can someone let me in on the secret? I'm not a codebreaker, and google hasn't been very helpful either hmm

Endre's Website

  • Smartys
  • Former PunBB Developer
  • Offline
  • Registered: 2004-04-30
  • Posts: 7,844

Re: inserting date/time in database

Unixtime
http://www.onlineconversion.com/unix_time.htm

3 Reply by Endre (edited by Endre 2005-03-16 00:31)

  • Endre
  • Senior Member
  • Offline
  • From: Norway
  • Registered: 2005-02-20
  • Posts: 165

Re: inserting date/time in database

thanks, you're a lifesaver! (or at least you saved me from 2000 disgruntled forum users, lol)

Endre's Website

4 Reply by D9r

  • D9r
  • Senior Member
  • Offline
  • From: Atlanta, Georgia
  • Registered: 2004-08-18
  • Posts: 148

Re: inserting date/time in database

Good stuff.  I need to save this link for quick reference.  Thanks, Smartys.

Dean
One of these days, I'm going to upgrade my forum.
D9r.com - homepage
Tucker & DeKalb County, Georgia -- news, events, zoning, politics, directory
HiveMinds.info - International Web Developer Forum (lots of smart folks here)

D9r's Website

  • Registered: 2004-08-08
  • Posts: 508

Re: inserting date/time in database

Try this one too -> https://addons.mozilla.org/extensions/m … on=firefox