• From: Brittany (France)
  • Registered: 2005-01-11
  • Posts: 30

Topic: converting a date (yyyy-mm-dd hh:mm:ss) to punbb date format

Hi
I have a table with a field 'register_date ' which stores date_time values.
I would like to insert this in the punbbusers table, but don't how to convert datetime into timestamp.
Should be straight foreward, but I can't find any help on the mysql doc...

Thomas

tomlelab's Website

  • From: Brittany (France)
  • Registered: 2005-01-11
  • Posts: 30

Re: converting a date (yyyy-mm-dd hh:mm:ss) to punbb date format

Ok I finally found out, just use unix_timestamp() .
(it just didn't work int he first place...)

tomlelab's Website