How to convert a column with dates to a unix timestamp?

Und alles was mit phpMyAdmin seine Verwandtschaft findet hat hier seinen Platz.

How to convert a column with dates to a unix timestamp?

Postby CloeSt » 27. January 2012 14:59

I'm importing posts into a forum. However the forum requires the dates to be in a unix timestamp form.
I imported it as normal dates...

Is there an SQL query or something that I can use to convert that column with dates to a unix timestamp?
CloeSt
 
Posts: 4
Joined: 01. December 2011 11:56
XAMPP Version: 1.8.0
Operating System: windows 7

Re: How to convert a column with dates to a unix timestamp?

Postby Altrea » 27. January 2012 16:56

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
free software according to purpose of usage
XAMPP 1.8 for local development/testing only
Zend Server 6 (free) for production environments
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 4509
Joined: 17. August 2009 13:05
XAMPP Version: 1.8.0
Operating System: W7Ux64


Return to phpMyAdmin

Who is online

Users browsing this forum: No registered users and 2 guests