RE: [PHP-DB] Converting Dates...

2003-03-05 Thread John W. Holmes
> I need help. I need to convert a Date column in MySQL where the date is > stored like "2003-01-15" to the following seconds "1042621252 ". SELECT TO_UNIXTIME(date_column) AS formatted_column FROM yourtable WHERE ... The TO_UNIXTIME() function will convert the date to the format you need that

[PHP-DB] Converting Dates...

2003-03-05 Thread Doug Coning
Hi, I need help. I need to convert a Date column in MySQL where the date is stored like "2003-01-15" to the following seconds "1042621252 ". I'm connecting the database through PHP to third party solution that requires this. Here is the only information that was given: