1
novlang1984
How to "encode" a date ?

I would like to import datas from a csv file into a Xoops module. One column is named date and contains data like : 2010-05-29

Before to proceed I must transform 2010-05-29 to have something like "1307667470"

Is there a quick way to do that ? Any link / idea is very wellcome, thanks in advance :) !

2
novlang1984
Re: How to "encode" a date ?

Sorry, response is SELECT UNIX_TIMESTAMP( 'date' )

... and an useful tool is there : http://www.epochconverter.com/epoch/batch-convert.php

Login

Who's Online

342 user(s) are online (188 user(s) are browsing Support Forums)


Members: 0


Guests: 342


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits